topic Dimension,Fact and Link Table in QlikView

Dimension,Fact and Link Table

sivarajs — Thu, 14 Feb 2013 09:36:26 GMT

Hi,

I just wanted to what is dimension , fact and a link table?

Give me a exemple to show all the three tables

Regards,

Sivaraj

Re: Dimension,Fact and Link Table

er_mohit — Thu, 14 Feb 2013 10:02:02 GMT

hiiii

http://en.wikipedia.org/wiki/Star_schema

http://searchdatamanagement.techtarget.com/definition/fact-table

http://community.qlik.com/thread/60741

hope it helps you

see teh attached file also

Re: Dimension,Fact and Link Table

Gysbert_Wassenaar — Thu, 14 Feb 2013 11:00:14 GMT

See here for an example of a link table used to link dates (=dimensions) from several tables. A fact is something you want to calculate with. Like SalesAmount where you might want to calculate sum(SalesAmount) or avg(SalesAmount). In Qlikview any field (fact or not) is a dimension.

Dimension tables and fact tables are basic business intelligence concepts. Read for example the descriptions of Fact tables and Dimension tables. In Qlikview a chart can have dimensions and expressions. This has little to do with Dimension tables, but is just a term used in Qlikview in the context of charts. Think field instead of dimension and it'll probably look more familiar to you.

Link tables are used to link dimension and/or fact tables when direct links are not possible or have unpleasant effects. See this article for an explanation.

Re: Dimension,Fact and Link Table

sivarajs — Thu, 14 Feb 2013 12:56:20 GMT

@Gysbert : I am still confused with three tables. Can you explain me a little bit