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

Analytical Need 

We have multiple sources 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 Multi Fact Schema. This schema contains multiple fact table and multiple dimensions that are connected to them. Best practice recommends that all dimension tables will be directly connected to all Fact tables (this is in order to avoid indirect connections between tables - which can cause unwanted results. Would you like to know more? please refer to Handling Relationship Cycles).

The keys from the fact tables will need to become invisible, in order to prevent confusion in the dashboard design, where several fields will mean the same. That is why we will only keep the key field from the dimension tables and the filters in the dashboard will only use fields from the dim tables.

The ElastiCube schema will look like this:

 

Community_Admin_2-1634475879347.png

 Image 1. Typical Multi Fact Schema (Facts on the left , Dims on the right)

 Attachments

 - 473 KB - Multi Fact.ecdata

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

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

Need additional support?:

Community Support Request