|
|
|
|
|
Execution-MiH ENCYCLOPEDIA →
Enterprise Intelligence →
SECTION - Data Analysis/OLAP →
|
CHAPTER -
| Additivity and Aggregation of Measures-Facts in OLAP Analysis |
|
Additivity and correct aggregation methods application is fundamental to the success of Business Intelligence. The most common mistakes the modelers and designers make is on - Setting the Right Hierarchies AND Establishing Right Additivity and aggregation rules. You need to go through the chapter of business dimensional hierarchies, before you go through this chapter.
|
|
|
|
| |
Topics
|
|
Additivity of Measures-Facts
|
Additivity and correct aggregation methods application is fundamental to the success of Business Intelligence. The most common mistakes the modelers and designers make is on - Setting the Right Hierarchies AND Establishing Right Additivity and aggregation rules. You need to go through the chapter of business dimensional hierarchies, before you go through this chapter. Additivity of a measure is when you are able to apply the sum operator across all the dimensions. Other aggregations on measures-facts are when you use operators like Average, Maximum and Minimum.
|
| |
|
Non-Additive Measures-Facts
|
Non-Additivity is that when you cannot use a sum operator to generate the needed aggregation.
|
| |
|
Semi-Additive Measures-Facts
|
Semi-Additivity is when you can have a measure aggregated on a certain dimension, but not all the dimensions. Another phrase for semi-additivity is when you have the summarization with an index of in-accuracy.
|
| |
|
|
|
|
|
|
|
All Chapters in "Data Analysis/OLAP." Section
|
|
|
|
| |
| |
| Back |
