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.
Comments
Post a Comment