|
|
|
| Business Performance and Information Excellence Practice
|
|
|
|
|
|
|
BiPM ENCYCLOPEDIA →
Intelligent Enterprise →
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 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-Additivity is that when you cannot use a sum operator to generate the needed aggregation.
|
| |
|
|
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 |
|
|
|
|
|
