Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Transaction and snapshot data model

Hi,

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

2 Replies
Partner
Partner

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

Digital Support
Digital Support

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.