topic Re: Dimension in QlikView

Dimension

qlikview979 — Thu, 23 Apr 2015 06:16:30 GMT

Hi experts,

What is the dimension table? what is the use ?

Re: Dimension

Thu, 23 Apr 2015 06:18:35 GMT

Dimensions and Facts | Learn QlikView

Re: Dimension

MK_QSL — Thu, 23 Apr 2015 06:19:03 GMT

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..

Re: Dimension

prma7799 — Thu, 23 Apr 2015 06:19:37 GMT

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

Re: Dimension

Thu, 23 Apr 2015 06:19:43 GMT

another one

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

Re: Dimension

rajeshvaswani77 — Thu, 23 Apr 2015 06:24:31 GMT

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

Re: Dimension

jagan — Thu, 23 Apr 2015 06:27:07 GMT

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.