Forum Discussion

pe2950's avatar
pe2950
Helper I
7 years ago
Solved

Duplicate DateKey Relationship To 1 Table? (Correct Model Configuration?)

I'm attempting to configure my data model, but have a question as to 'best practice' for this type of situation...   I have a table that contains appointments. The appointments have two date proper...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hi pe2950,

     

    your scenario is known as Role Playing Dimensions. You can create an active relationship between the Date dimension and the column from the fact table which you're more likely to use and an inactive relationship between the Date dimension and the other column in the fact table. When you want to browse your model by the date of the inactive relationship use the USERELATIONSHIP  function to activate it in your measure

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Hi pe2950,

 

your scenario is known as Role Playing Dimensions. You can create an active relationship between the Date dimension and the column from the fact table which you're more likely to use and an inactive relationship between the Date dimension and the other column in the fact table. When you want to browse your model by the date of the inactive relationship use the USERELATIONSHIP  function to activate it in your measure