Many to many relationship between Fact & Dimension

Tue, 08 Apr 2014 05:37:46 GMT

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?

Thanks

topic Many to many relationship between Fact & Dimension in QlikView

Many to many relationship between Fact & Dimension