Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed. Provide feedback and/or content requests via the Share BETA Feedback forms found below.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Many-to-Many Relationships - Knowing and Avoiding Them

Introduction The following article discussed "Many-to-Many" relationships - Both expected and unexpected. It focuses on how they occur and the best practices which one can implement to avoid them. Table of Contents IntroductionTable of ContentsTable ...

Ophir_Buchman_0-1644955176043.png Ophir_Buchman_2-1644955319311.png Ophir_Buchman_3-1644955380874.png Ophir_Buchman_0-1645470915372.png

Planning, Executing, and Monitoring your Dashboard

Introduction The following article discusses a dashboard's (high-level) development cycle. It breaks the process into easy measurable steps that start from the initial KPI planning all the way to maintaining and adjusting your end product. Table of C...

Ophir_0-1643098274233.png Ophir_1-1643098337878.png Ophir_2-1643098738509.png Ophir_0-1643099067104.png

Choosing the Right Data Model for You

Introduction Customers often run into the question of what data model they should use (an Elasticube or a Live Model). The following article presents a few of the aspects you should consider when choosing between them. Sisense recommends you discuss ...

Modelling Aggregate Facts

Analytical Need There are cases where our data arrives in aggregate form, like in Google Analytics (where the lowest granularity level is daily). If we wish to free up clutter in the dashboard and prevent the user from figuring out which field comes ...

Community_Admin_2-1634724930802.jpeg Community_Admin_3-1634724930845.jpeg

Build A Flattened Hierarchy From 2 Levels

Analytical Need In many cases a hierarchy appears in the data structured as 2 levels - A parent and a child. The business user would like to see the entire hierarchy and analyze the data according to the different levels, but can't do that since they...

Community_Admin_0-1634724811074.jpeg Community_Admin_1-1634724811153.jpeg

Calculate Average Time Between Transactions

Introduction Calculating transaction frequency for a given dimension is a common requirement across many verticals. e.g. Average Time Between Purchases by a Customer. Average Time between support tickets etc. While this can be calculated in SQL it ca...

Calculating Values For The Most Recent Date

The point of this article is to provide a method to a value associated with the most recent data in a date selection. Implementation Step 1: in the Elasticube, create a field transforming the date field into an integer using the formula below. Then r...

Community_Admin_0-1634681408782.png Community_Admin_1-1634681408855.png Community_Admin_2-1634681408858.png Community_Admin_3-1634681408852.png

Elasticube Modeling With Data Security: Best Practices

Adding Data Security to an existing Elasticube Model can have little to great effect on the performance of the system. It is important to already have planned the Elasticube Model with the intention to apply Data Security in the future. This article ...

Community_Admin_0-1634680887043.png Community_Admin_1-1634680887154.png Community_Admin_2-1634680887021.png Community_Admin_3-1634680886944.png

Formulas Creating "Random Paths" Between Dimensions

Problem Advanced formulas can sometimes return wrong results (or no results at all) when combining dimension-affiliated calculations** with dashboard or widget filters based on a second dimension. Certain calculations may include backstage joins betw...

Community_Admin_0-1634653177872.png Community_Admin_1-1634653177834.png Community_Admin_2-1634653177883.png Community_Admin_3-1634653177908.png

Creating 'From-To' Date using BloX

Analytical Need Attached below is a BloX template. A common request is to have a 'From To' input at the top of the dashboard to affect a calendar range selection of dates. To achieve this need we can utilize BloX's form capabilities. Picking a date r...

Community_Admin_0-1634624683332.png Community_Admin_0-1634624776088.png

Fiscal Year Adjustments

Analytical Need Customer's fiscal year does not comply with the Georgian 12-month calendar and starts on a different date than January 1st. Example: Customer’s fiscal year is from April 1st to March 31. This means that April should be flagged as the ...

Many to Many by Design (Relationship Table)

Analytical Need There are cases where we need to define an association between two entities. This association is comprised of the entities and not by each of them separately. For example, students & courses. We need to have a list of each student, a ...

Community_Admin_9-1634557195626.png Community_Admin_10-1634557195638.png Community_Admin_11-1634557195680.png Community_Admin_12-1634557195700.png

Modelling Different Granularity Levels

Analytical Need There are many cases where our data comes in with different granularity levels. For instance, Actual vs. Target where the actuals are at the product level and the targets are per sub category (higher hierarchy of the product). How can...

Community_Admin_2-1634556920980.jpeg Community_Admin_3-1634556920973.jpeg Community_Admin_4-1634556920957.jpeg

Analyze Period over Period - MoM / WoW / DoD

Analytical Need There are cases where we want to analyze our measures as a comparison between periods of time. For instance, we want to know how did our measures behave on January this year vs. previous year. This means that we have to put down in ou...

Community_Admin_5-1634556801381.png Community_Admin_4-1634556756281.png