Forum Discussion
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...
I have a similar use case where I have effective dates and expiration dates. I use 3 different date tables, one for Effective (active), one for expiration date (Inactive) and one main date table for filtering that has an active relationship to both of the other date tables. I specify which relationship I want to use regarding the fact table to the sub date tables in each measure. Then I use the main date table for all filters. This filters each of the sub date tables appropriately.
I see that this post is old, but hope it helps someone.