Dimensions in Qlikview
Types of Dimensions in QlikView
If the dimension is shared by multiple fact tables then the dimension is called as Confirmed Dimension.
It is an attribute in the fact table and used to satisfy the latest requirements from the customer.
Ex: Avg No of goods sold per order= Sales Qty/OrderNo
The Dimension which Contains textual codes(Abbrevations) and flag variables is called Junk Dimension
Ex:Textual Codes - IND,USD,AUD
Flag Variables - Yes/No Male/Female True/False 1/0
If the dimension contains more number of columns(>100) or more number of rows(>2million), then it is called as large or monster dimension.
If the dimension contains less number of columns(<5) and less number of rows(<1000) then it is called as mini dimension.
Slowing Changing Dimension(SCD)
The dimension which changes w.r.t number of rows or number of columns over a period of time, is called as slowly changing dimension.
SCD are of 3 Types
-Type1 - It maintains latest data only
-Type2 - It maintains complete data about all transactions
-Type3 - It maintains current values along with immediate previous values
|Pno||Pname||Prev Cost||Present Cost|
If the dimension is loaded with data only once in a project life cycle time and will never change then it is called as static dimension.
Ex: Country - India,Pakistan,Sri Lanka
Currencies - USD,INR,AUD
Multi valued Dimension
If the dimension attributes contains many to many relationship within the data then the dimension is called as multi valued dimension.