Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Dimensions & Facts ?

Hi All,

How to Split Dimensions & Facts, while doing Scripting for the Data Model..

consider that, I am having 20 tables i have to do linking..

Can any one explain me with Some Steps or give me some example for that.

Thanks,

Helen

2 Replies

Re: Dimensions & Facts ?

Use transaction table as Fact tables and the master tables as the dimensional tables or use as dimensions. And follow the Star schema or the Snow flake schema for data model.

Or Refer the attached documents for fact creation

For Dimensional modelling

Relational vs. Dimensional Data Model

http://www.quickqlearqool.nl/?p=910

Re: Dimensions & Facts ?

Hi

Attached document might help you.

Regards

ASHFAQ

Community Browser