Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to create data model based on transaction fact table and snapshot fact table with 7-8 common dimensions?
I created link table with concatenated key consist of all common dimensions but customer does not want to see composite keys in data model and neither they are OK with concatenation approach
Just wanted to toss out the following for you as well as the Design Blog area, these may help you look into other approaches.
Help:
Design Blog area:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett