topic Transaction and snapshot data model in QlikView

Transaction and snapshot data model

vsharma1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Re: Transaction and snapshot data model

vsharma1 — Sun, 14 Jul 2019 08:01:58 GMT

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

Re: Transaction and snapshot data model

Brett_Bleess — Wed, 31 Jul 2019 14:32:45 GMT

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-practices-data-modeling.htm

Design Blog area:

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

Regards,
Brett