Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
  Non-Additive Measures-Facts  

ENCYCLOPEDIA→   Enterprise Intelligence  →   -  Data Analysis/OLAP  →   -  Additivity and Aggregation of Measures-Facts in OLAP Analysis  → 

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.

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, through the entire hierarchy path. Other aggregations on measures-facts are, when you use operators like Average, Maximum and Minimum. The topics in this chapter are focused on the areas which have additivity OR aggregation constraints. For measures, which do not fall into these constraints are considered Additive..

The OLAP tools now-a-days have some capability to automatically enforce the correct additivity and Averaging rules, given the hierarchy and the type of measure. However, the burden is finally on the modelers and designers.

Before we move further, let's take a look at some more aspects, which will be useful:

Completeness of Hierarchy:

This basically means that all the possible instances of a hierarchy path to be available, to make it complete. It means that there should be no missing data in the tables. For example, if you have country and continent level in the location dimension, one should expect that all the countries in the Europe continent should exist in the tables. Otherwise your summarization for the continent may not work.

Classification vs. descriptive attributes:

A classification attribute of a dimension is the attribute, on which the aggregation takes place. A dimensional attribute is the one, which plays the role of a descriptor and is not the basis of aggregation. You will see that OLAP includes all classification attributes and some descriptive attributes.

 

  Non-Additive Measures-Facts  
 
 

Was this page helpful?
 
 
More on Additivity & Aggregation-Facts
Non-Additive Measures-Facts
Semi-Additive Measures-Facts
BUY BI & Data Management Vendors & Tools Evaluation Kit
Read more...
BUY largest on-line Data-Quality Management Kit
Read more...
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators



Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Data Management in Sales Campaign
Sales Channel Partner Acquisition
Sales Compensation System
Sales Leads Generation through advertising
Enhancing Sales Channel productivity
Read more...
  Customer Relationship Management
Customer Segmentation Parameters
Customer Value and Profitability Data Management
Customer Knowledge and Organizational Knowledge
Supply Chain for Customer Service and Support
Customer Segmentation Data Management
Read more...
  Human Resources & Leadership
Feedback does not mean only negative feedback
People become the way you treat them
Lead diverse and collaborative teams
Lead Change
Leadership Development- Setting the Context
Read more...
 
 
Business Performance & Planning
Performance Review should have no surprises
Strategic Planning leadership commitment
3-4 hours in reviewing a scorecard.
Strategic Planning Business Themes
Dashboard Health Checklist
Read more...
  Business Intelligence & Data Quality
Data Group Master
Knowledge Discovery in Databases Process
Data Monitoring through diagnostics
Data Warehouse BI Staging Area
Master-Data-Management CDI Architecture
Read more...
  IT Vendors & Tools Management
Single point vendor needs to be cost-effective
Collaboration and Administration Support
Design & Analysis support and Wizards
Vendor Evaluation Matrix
Security Technical Evaluation
Read more...