Forum Discussion

Murat_Taha's avatar
Murat_Taha
New Member
3 years ago

About Data Relationships

 

The above model contains product groups. These product groups have been updated three times in a 10-year period. I am trying to establish a relationship with the 01_UN table below by filtering it based on these three revisions. I created a new table named 000_HS_Rev and linked it to the fact table, but the filters did not work on the product groups. Thank you in advance for your help.

1 Reply

  • Please read about SCD - Slow Changing Dimensions.  After that please correct your data model.