• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Dimensions in Qlikview

Types of Dimensions in QlikView

Confirmed Dimension

If the dimension is shared by multiple fact tables then the dimension is called as Confirmed Dimension.

Capture.602

Degenerate 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

Junk Dimension

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

Large Dimension

If the dimension contains more number of columns(>100) or more number of rows(>2million), then it is called as large or monster dimension.

Mini 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

Example:  

PnoPnameCost
101lux10
102rexona14

Type I

PnoPnameCost
101lux12
102rexona14

Type II

PnoPnameCost
101lux10
102rexona14
101lux12

Type III

PnoPnamePrev CostPresent Cost
101lux1012
102rexona14

Static Dimension

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

Aggregate Dimension

The dimension which is loaded at base level and is possible to calculate aggregate functions like sum(),avg(),min() etc is called as aggregate dimension.

Multi valued Dimension

If the dimension attributes contains many to many relationship within the data then the dimension is called as multi valued dimension.

Example

CarColor
Swiftred
Swiftwhite
Swiftblue
Santrored
Santrowhite
Santroblue
Summary
Review Date
Reviewed Item
Dimensions in Qlikview
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Dimensions in Qlikview"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.