topic Re: What is difference b/w Dimensions & Fact Table in qlikview? in QlikView

What is difference b/w Dimensions & Fact Table in qlikview?

Fri, 20 Nov 2020 18:02:30 GMT

Please Explain.

Re: What is difference b/w Dimensions & Fact Table in qlikview?

MK_QSL — Tue, 22 Jul 2014 08:24:35 GMT

Fact Table contains measures on which we can do further calculations to get analysis.

Dimensions are simply fields for which we are doing analysis on measure...
Kindly read below blog to get clarity...

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/25/dimensions-and-measures

Re: What is difference b/w Dimensions & Fact Table in qlikview?

ramasaisaksoft — Tue, 22 Jul 2014 12:46:47 GMT

Hi Ramesh,

As per my knowledge in simple words

--> combination of some Dimensions values get into Fact Tables

-->Always Fact table data or Rows are more than Dimension table.

-->we will create fact table columns from different dimension tables.like

fact_Reservation Table

Book_date from Dim1.Book_Date

sales from Dim2.Sales

cost from Dim3.Cost(Here Dim3 is Dimension name and Cost is Column Name)

i hope it is helpful to you.

Re: What is difference b/w Dimensions & Fact Table in qlikview?

Tue, 22 Jul 2014 12:55:24 GMT

Hi Ramesh,

What is a Dimension or a dimension Table

In Data warehousing, dimension table contains the textual or descriptive attribute of the data.

For example, Customer dimension will contain details about customer’s name,address,phone number etc.

Dimensions are used to slice and dice the data i.e. filter and group the data.Dimension table also help you by looking at data with “By” attribute i.e. say if the Total sales of the company is $1 Million then using Customer dimension you can look at the Total sales “By” Customer or “By” Time. A dimension table has a primary key column also called Dimension ID/Dim Id that uniquely identifies each dimension row. The dimension table is associated with a fact table using this key.

What is a Fact Table

Fact Table contains the measurable attribute of the data. It contains measurable data that can be analyzed by Dimension tables. Fact tables contain the foreign keys of the associated Dimension tables.

Regards,

Senthil

Re: What is difference b/w Dimensions & Fact Table in qlikview?

Tue, 22 Jul 2014 13:11:33 GMT

Checkout this write up on dimensional modeling by Ralph Kimball:

http://www.kimballgroup.com/1997/08/a-dimensional-modeling-manifesto/