Dimension

[qlikview979]

Hi experts,

What is the dimension table? what is the use ?

[#2]

Dimensions and Facts | Learn QlikView

[MK_QSL]

Dimension Tables are table having only Dimensions and no Fact Data or Transaction Data.

For Sales environment...

SalesTable or InvoiceTable is Transaction or Fact Table

Customer, Employee, Supplier Tables are Dimension Tables..

[prma7799]

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 $1Million 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.

Or you can check the below link...

Dimension,Fact and Link Table

Thanks

PM

[#5]

another one

What is the difference between a fact table and a dimension table ?

[rajeshvaswani77]

Hi Mahesh,

Dimension will normally contain reference data. This can be data like:

Country Code, Country Name

Product Code, Product name

Normally the data in the dimension table will not change much. The dimension table data would be used mainly to lookup, also to see how relative to a particular dimension the expressions would aggregate.

The transaction data will not be stored in the dimension tables.

thanks,

Rajesh Vaswani

[jagan]

Hi Mahesh,

Dimension tables contain attributes that describe fact records in the fact table. Some of these attributes provide descriptive information; others are used to specify how fact table data should be summarized to provide useful information to the analyst.

For example :

Take Sales data

For sales you will have Product, Salesman, Product Category, Branch etc, Sales Price, Quantity etc.

Here Product, Salesman, Product Category, Branch are called Dimensions because this attributes provides the descriptive information about the transaction.  That is Product 1 of Product Category A is sold by Salesman X of Branch B1.  So this are called dimensions where as Sales Price and Quantity are called Measures.

In realtime scenario, we will have separate tables for all this dimensions, and this dimensions are referred by their IDs in the Transaction table, for example Product ID, ProductCategoryID, SalesmanID and BranchID etc.

Hope this info helps you in understanding.

Regards,

Jagan.