✍ Kashif M
Trends

Sunday, 17 November 2013


What is Measure in Data warehouse


By on November 17, 2013



Measure is normally a numeric value represents business values.

Can have multiple measures in a fact table.

Measures unlike dimensions give the fact numeric value instead of the detailed analysis.

Different types of measures are listed below:

1. Additive measures are measures that can be added across all dimensions. For example customer count in numbers can be added across all dimensions.

2. Semi-additive measures are measures that can be added across some, but not all dimensions. For example the bank account balance is simply a snapshot in time and cannot be added over time. However you could add multiple accounts of the same customer to get the total balance for that customer.

3. Non-additive measures are measures that cannot be added across any dimensions. For example the procurement is simply a snapshot in time and cannot be summed over time. Also you cannot combine procurement for various items.

Kashif
mkashu: What is Measure in Data warehouse
Review : Kashif | Kashif
Update: November 17, 2013 | Rating: 4.5

Comment for "What is Measure in Data warehouse "

0 comments

Post a Comment