Forum Discussion

DataventureNL's avatar
DataventureNL
New Member
4 years ago

Case: Model with multiple historical tables

Goal We want to build visuals based on multiple historical tables with time dimensions. These visuals should respond to the Referencedate (range) set by the report consumer by setting a filter or re...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Think about which tables are fact tables and which tables are dimension tables

Create a star/snowflake schema accordingly.  It is ok for one dimension table to control two fact tables. Fact tables should not be linked to each other.

For multiple dates in your logic you can create inactive relationships from the calendar dimension table to the fact tables. The your measure formula can work with USERELATIONSHIP as needed.