A relationship between tables specifies the field/s which the 2 tables have in common. In Sisense, we create relationships between tables in the ElastiCube. Poorly modeled data relationships can lead to one or more of the following: Complex data se...
Analytical NeedAnalyzing information by date can be very useful, but not every source data set provides enough information to do this kind of analysis.Modeling ChallengeWe will need to import a date table, which will act as a reference for all time q...
Analytical Need For a metric, I need to calculate the month difference between the min and max date of purchase for each brand in my dataset. I want the dates to be dynamic in respect to filtering, etc. I am using the attached .ecdata and .dash fi...
Question What is the reason of adding a custom tables in the ElastiCube? As I understand all the customizations and calculations should be done in the Dashboard itself, so why do we need to create custom tables? Answer The reason to create the t...
Question We have multiple clients and to maintain this we modeled the dim_client table and we implemented the data security rules on this table. We have 2 fact tables (fact_sales and fact_budget) to have the sales information and sales target inform...
Question How to do a lookup using two conditions (i.e., pulling project number on a unique equipment for a specific day)? Answer You can only use one field as the key field in Lookup function. So, it is better to create a combined key (using conca...
