Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member

Analytical Need 

We have one central source for our measures and multiple sources to slice & dice these measures.

Modeling Challenge

How do we build a schema that will enable us to perform our needed analysis?

We will need to connect all of our tables so every criteria will be able to filter the population for the measures.


We will build a Star Schema. This schema contains one fact table and multiple dimensions that are connected to it. This is the most recommended model performance wise (when possible) and the simplest one to understand (Except for a schema with one table).

The ElastiCube schema will look like this:



 Image 1. Typical Star Schema 

 - 2.7 MB - Star Schema.ecdata

Version history
Last update:
‎10-17-2021 06:42 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy