mobileNavlogo
headerlogo

Dimensions in Qlikview

19 September, 2018

Ratings

Related Blogs

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:  

Pno Pname Cost
101 lux 10
102 rexona 14

Type I

Pno Pname Cost
101 lux 12
102 rexona 14

Type II

Pno Pname Cost
101 lux 10
102 rexona 14
101 lux 12

Type III

Pno Pname Prev Cost Present Cost
101 lux 10 12
102 rexona - 14

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

Car Color
Swift red
Swift white
Swift blue
Santro red
Santro white
Santro blue
About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .