Forum Discussion
Continued ContributorDate Range Based on User
I found a solution that seems preferable over creating a Dim Dates table that has a User column as this would greatly multiply the size of my Dim Date table (there are many more Users than the two cited above).
I set the cross-filtering direction between the DimDate table and the Fact table to Both instead of Single. I also set the cross-filtering direction to Both between the Dim User table and the Fact table. Now, it works as expected.
I am marking this as the solution, but feel free to comment if there are potential pitfalls to this solution that I am unaware of.
Continued ContributorI found a solution that seems preferable over creating a Dim Dates table that has a User column as this would greatly multiply the size of my Dim Date table (there are many more Users than the two cited above).
I set the cross-filtering direction between the DimDate table and the Fact table to Both instead of Single. I also set the cross-filtering direction to Both between the Dim User table and the Fact table. Now, it works as expected.
I am marking this as the solution, but feel free to comment if there are potential pitfalls to this solution that I am unaware of.
Super User
Just a word of caution is when the cross filter is set to both, any other queries or filters done where it connects to the Fact table will then also go and filter the date table. So there could be instances where there are the wrong values!