This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Analytical Need Calculate the time difference between two events in a fact table.In the example, we want to measure how many days it took to complete each task in a shipment process. Modeling ChallengeOrders fact table has 3 fields: Order ID, Status...
Analytical Need You want to display several ‘to date’ calculations for multiple time frames (i.e. week to date, month to date, year to date) based on a date selected by dashboard viewer. You want it to be visually appealing and minimize the work fo...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-ManyData Relationships: Check Type of relationshipData Relationships: O...
Analytical Need With a Parent – Child hierarchy that has 3 levels, there must be a series of dependent filters for all levels individually but, affects the other levels below it too. Business defined hierarchy Level I - Line of Business (LOB) { ...
Business CaseCreating a “Date” table which is identified by a numeric representation of a Date field instead of the Date field itself may improve the query performances. In addition, a numeric representation of a Date can provide us later on with the...
The Problem Date information from the source is represented as an integer, with the format YYYYMMDD. We need the information to be represented as a date-time data type in Sisense. The Solution This will utilize a custom field to convert the valu...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-ManyData Relationships: Check Type of relationship (You are here)Data R...
When would I use this: In cases when you have a table containing an identifier field with a related field containing delimited text and you need to split into a new row per split subfield. Example: The Email Address column contains email addresses ...
Analytical Need Using the lookup function to import data from one table to enhance another, based on specific conditions or filters. This might be required if we wish to import attributes from a table which is not unique. For example, a transpose...
Analytical Need Certain business questions might require us to determine the time that has passed between two status in a flexible manner.Calculating differences between two events often will require using functions such as YDIFF/MDIFF/SDIFF that...
This article outlines how to create a date table that flags whether or not a particular date is within a particular range, based off of the current date. For example, if today is the 100th day of the year, we may want to analyze information for the f...
In multiple fact tables, that all contain a common field, when filtering on this field in a dashboard, you want the filter to be independent of all of the related fact tables.In order to accomplish this, you’ll need to generate a dimension table for ...
When pulling together data from multiple sources, you’ll have a number of different dates. For instance, the marketing department has a Campaign Date, Sales department may have an Opportunity Date and Finance has a GL Date. Modeling Challenge This ...
Sisense does not currently support the Cross Apply operator but below shows a viable alternative. The easiest way to implement this would be to import the data returned from a stored procedure directly into an ElastiCube table. You can do this by edi...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
