Forum Discussion
Solved
Drill Through Issue
I have two dates in my fact table Created Date and Solved Date. I have a few calculations that use both these fields. I have active relationship on CreatedDate to DimDate while I have inactive betwee...
On your summary page chart, don't use the Created Date but instead use dimDate. That way the dimDate will be passed through as a filter to your drill through page and you can use USERELATIONSHIP to activate the appropriate relationship in each measure.
I think the best option would be using separate role-playing date tables
- DimDateCreated → active to Fact[Created Date]
- DimDateSolved → active to Fact[Solved Date]
Then use the appropriate date field for the visual / drillthrough depending on whether you want Created or Solved context.If you need both independently, this is the most reliable pattern.
On your summary page chart, don't use the Created Date but instead use dimDate. That way the dimDate will be passed through as a filter to your drill through page and you can use USERELATIONSHIP to activate the appropriate relationship in each measure.