Forum Discussion
Solved
Data Modeling - Multiple Fact Columns in one dimension Table / one Hierarchy
Hello! I need to create a report where I can display multiple granularity details in a single fields/column of a Matrix. This basically means that some rows from the source table will be counted mu...
Your dimension table 2 needs to stay disconnected for this to work. Your composite key (table 1) is not required, and table 3 is not required either.
Repeating data in the same visual is a design red flag.
see attached.
Your dimension table 2 needs to stay disconnected for this to work. Your composite key (table 1) is not required, and table 3 is not required either.
Repeating data in the same visual is a design red flag.
see attached.