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

mceclip1.png Analytical Need 

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

mceclip2.png 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

mceclip3.png Solution

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:
‎03-02-2023 08:51 AM
Updated by:
Community Toolbox

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

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: