cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
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.

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:

Community_Admin_0-1634478131850.png

 

 Image 1. Typical Star Schema 

 - 2.7 MB - Star Schema.ecdata



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

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

Need additional support?:

Community Support Request