Forum Discussion

Hind26's avatar
Hind26
Icon for Advocate I rankAdvocate I
8 years ago

Multiple relationships with Date report filter

Hi, I have a Fact Table that contain two different Date (exple : Creation and Update) and i have Date Dimension, beside all this i have a Date Report filter that i did from my Date dimension and i w...
Need Help
rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
8 years ago

You can make relationship on these two dates.One active and another one inactive.

 

You can create active relationship on the one that is used most while calculating a measure , and can use USERELATIONSHIP whenever you want to use other date.

 

Hope this helps,

Thanks!

  • Hind26's avatar
    Hind26
    Icon for Advocate I rankAdvocate I
    8 years ago

    Thank you for your answer, i have already tried this solution, but i figured out that using the function UseRelationship on the inactive relationship inactivate the other one, it doesn't work in addition on my existing active relationship.

    • rajulshah's avatar
      rajulshah
      Icon for Resident Rockstar rankResident Rockstar
      8 years ago

      Sorry , but you cannot have more than one relationship between two tables.

      • Hind26's avatar
        Hind26
        Icon for Advocate I rankAdvocate I
        8 years ago

        So there is any other possible way to filter on the Report Date filter and my two dates be automatically included in the range chosen by the user in the filter?