Transaction and snapshot data model - Qlik Community

vsharma1 · ‎2019-07-06

Hi,

How to create data model based on transaction fact table and snapshot fact table with 7-8 common dimensions?

vsharma1 · ‎2019-07-14

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

Brett_Bleess · ‎2019-07-31

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:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/LoadData/best...

Design Blog area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.