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 In many use-cases, there’s a need to measure entities throughout their life cycle which spans from their ‘Start’ date to ‘End’ date. For example insurance company wants to count how many active policies there are on any given day. ...
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-Many Data Relationships: Check Type of relationshipData Relationships: ...
Analytical NeedCohort is a group of items who share common characteristic over a certain period of time. The Cohort analysis helps us identify the relationship between their characteristic and their behavior along relative periods of time. Modeling...
Introduction Surrogate Keys are mainly used for creating a single identifier for multiple dimensions, mainly when building a Key Table. A text key can be easily generated by concatenating the text and delimiters, however, text can become very long a...
Analytical NeedData security is implemented when there is a need to prevent the users from seeing the entire set of data. Each user only needs to see a data set based on permissions that is defined in Sisense Web. Here we will discuss how to solve a...
At times, you might want to limit the items suggested in a dashboard filter by another field's value (for example: enable the user to choose between all subcategories under a specific Product Category). This functionality can be achieved using a depe...
Analytical Need When we want to measure the service level we provide our customers we can do that using many different KPIs. These differentiate between industries and management decisions. This modeling use case is focused on employees in stores...
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...
The following article describes how to answer the following question: Which countries have sales for product A but not for product B The solution is based on using the Filtered Measure plugin. 1. Go over the instructions in the Technical Details of t...
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) { ...
Intro One may want to delete the connection credentials entered in ElastiCube Manager. This to prevent other users who have access to the server, being able to connect to the data source on their own - and getting access to sensitive data. steps: ...
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...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
