cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
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
Rate this article:
Version history
Last update:
‎03-02-2023 08:51 AM
Updated by:
Contributors