what is the best datamodel for Qlikview in this case

[#1]

Hi,

The below image is just a snapshot of a very big data model. Basically we have start schema so there is one big fact table with around 150 fields. Then there are many dimension tables directly attached to the fact table. Everything looks working but now we have comeup with a requirement where we have a combination of two id columns that result into million of records. The attached image simulates our requirement

Can someone please recommend what would be the recommended data model for us in this case. Should we just combine the contract dimension table and the link table or what would be the best solution for this

[krishna20]

Hi,

To Minimize the Datamodel structure.It's better you to approach Apply Map().

[maxgro]

yes if you only have one contract for record of fact table (RowId I suppose)

[hic]

Join ContractRowLink with Fact, but keep the smaller tables as they are.

HIC

[#5]

RowId and ContractId has many to many relationship so a join will surely messup everything