Drill-across to temporal fact table - Data model design

[Anonymous]

I am currently modelling a Kimball example where i need to drill-across between two fact tables. The first table FactReadings holds meter readings on the installation. The seccond table FactSupplier holds who the current supplier is on the installation.

FactReadings: | InstallationSK | DateSK | MeterValue | 

FactSupplier: | InstallationSK | SupplierStartDateSK | SupplierEndDateSK | SupplierSK |

As shown abow the FactSupplier table records the period the supplier is associated with the installation ( start and end ). Readings can happen at any time between the start and end. What would the data model have to look like for me to be able to drill across from FactReading to FactSupplier and see who the supplier was for that meter reading?

[Anonymous]

Hi @Anonymous,

You can try to create a hierarchy column with the date columns which you mentioned, then use this hierarchy column as the axis. After these steps you can use drill-down drill-up button to switch the visual graphic.

Regards,

Xiaoxin Sheng