Forum Discussion
Handling Multiple dates inside visual
Anonymous
To do what you want you have to have role-playing date/time dimensions. You can't achieve it with just one Date table. Sorry. Please create as many date tables as there are dates you want to visualize independently.
Inactive relationships are created when one and the same table joins to another on 2 or more different fields. You don't have such a situation since in this case each date table will join to the same table on one (and different) field.
Thanks man, I did a little digging on role-playing dimensions and I understood what was missing. It's actually quite simple: since I had relationships with all dates, I was just a matter of using the maintenance end date as legend.
Anonymous
I'll give you a valuable piece of advice (one that one day may save your back if you follow it): Never use columns directly from fact tables to slice and dice data. Always use dimensions. In fact, fact tables should always be hidden from view and only measures should have direct access to their columns.
If you don't follow this advice, you'll have yourself to blame for incorrect figures in your measures in the future.