Many to many relationship between Fact & Dimension
Hello Qlikview Experts
Join between Fact and Dimension tables has many-to-many relation. "Flag" is the column used to join fact & dimension table
Dimension
ShowFlag
Flag
A&B
A
A&B
B
A&C
A
A&C
C
FACT
Date
Flag
Measure1
Jan2014
A
100
Jan2014
B
200
Jan2014
C
300
Feb2014
A
150
Feb2014
C
50
Mar2014
A
20
Mar2014
B
30
Users wanted to see the aggregate of A&B or A&C. "ShowFlag" is displayed as a listbox with "always 1 selected value" constraint enabled. Aggregation happens correctly based on the selection.
A DW/BI expert commented that this data model will duplicate rows in memory when the application is opened.
Is this true? Will Qlikview duplicate rows and create a Cartesian product in memory?