topic Re: Need help on Fact and Dimension Table in QlikView

Need help on Fact and Dimension Table

Wed, 12 Mar 2014 10:26:00 GMT

Hi ,

I am new in Qlikview Develpment . Need your help to know more on Fact and Dimension Tables.

If it is possible Can any one please provide me a sample application explaning the fact tables.

Thanks!

D J

MK_QSL — Wed, 12 Mar 2014 10:28:13 GMT

Dimension Tables are those in which the fields and data are not changing daily or regular basis

Something like Customer Table

Here Customer Name, Customer ID, Address, Country etc

Fact Tables are those tables in which data changing regularly or daily

Something like

Sales Table

Here Invoice Number, Invoice Date, Qty, Sales Price, Total etc

Hope this will help.

vikasmahajan — Wed, 12 Mar 2014 10:32:30 GMT

Fact Tables - > All Transactions tables

Dimensions -> All Primary Key

Pfa Sample Application

Vikas

maxgro — Wed, 12 Mar 2014 22:33:07 GMT

fact and dimension tables are part of dimensional modeling, are not exclusive to Qlik

you can find an interesting description here