One DIM has multiple relationships with Facts
In my model, there is a DIM table has a primary key that is WORKORDER_KEY, and it has relationships with 3 FACTs by WORKORDER_KEY.
In Analyze tab I added a attribute of one fact then the others of remaining facts were hidden.
Can you help me figure out what am I wrong here?
Best answer by Petr Olmer
However, when I use “Status DIQ”, I cannot slice it by “Category Name”, so “Category name” becomes hidden. In the same way, when I use “Category Name”, “Status DIQ” is not available.
See Understanding the Logical Data Model, chapter “Reading the model”, for more examples.