Print Page - Difference Between Regular and Measures Dimensions

Title: Difference Between Regular and Measures Dimensions
Post by: sunny bachan prasad on 08 Sep 2014 12:35:32 PM

Can anyone explain with example the difference between Regular and Measures Dimensions.

Thanks in advance.

Title: Re: Difference Between Regular and Measures Dimensions
Post by: MFGF on 08 Sep 2014 01:37:29 PM

Quote from: sunny bachan prasad on 08 Sep 2014 12:35:32 PM
Can anyone explain with example the difference between Regular and Measures Dimensions.

Thanks in advance.

Regular dimensions are descriptive data eg Product info, Geography info, Time info, Customer info etc. Measure dimensions are the measures (key performance indicators) you want to use.

MF.

Title: Re: Difference Between Regular and Measures Dimensions
Post by: Francis aka khayman on 08 Sep 2014 10:14:02 PM

Studying for an interview? 8)

Measure Dimensions are numbers or KPIs
example: Sales = 100, Quantity = 200, Inventory = 300, Sales Amount = 4,250.51

Regular Dimensions describe those numbers, usually answer the questions who, what, where and when among others
example:

Year= 2014 <-- Regular Dimension (Time)
Sales = 100 < -- Measure Dimension

Product = Tents <-- Regular Dimension (Product)
Quantity = 200 <-- Measure Dimension

Country = USA <-- Regular Dimension (Location)
Inventory = 300 <-- Measure Dimension

Sales Person = Khayman <-- Regular Dimension (Sales Person)
Sales Amount =4,250.51 <-- Measure Dimension

Quote from: sunny bachan prasad on 08 Sep 2014 12:35:32 PM
Can anyone explain with example the difference between Regular and Measures Dimensions.

Thanks in advance.

Title: Re: Difference Between Regular and Measures Dimensions
Post by: sunny bachan prasad on 09 Sep 2014 10:28:38 AM

Thanks all for sharing the information.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sunny bachan prasad on 08 Sep 2014 12:35:32 PM