|
|
|
| Business Performance and Information Excellence Practice
|
|
|
|
|
|
|
BiPM ENCYCLOPEDIA →
Intelligent Enterprise →
SECTION - Data Analysis/OLAP →
|
CHAPTER - Business Hierarchies in OLAP and Data Warehouse
|
The subject of hierarchies is relevant to both OLAP and BIPM Delivery - Data Warehousing/Marting. Modeling of data is done, both in DW and OLAP, keeping the hierarchies in mind. However, OLAP is the platform where the hierarchies are manifested in their final shape for the purpose of analysis.
|
|
| |
Topics
|
|
|
The subject of hierarchies is relevant to both OLAP and BIPM Delivery - Data Warehousing/Marting. Modeling of data is done, both in DW and OLAP, keeping the hierarchies in mind. However, OLAP is the platform where the hierarchies are manifested in their final shape for the purpose of analysis.
|
| |
|
|
Simple or strict hierarchy is the simplest form of business Hierarchies.
|
| |
|
|
Non-Strict hierarchy has one similarity and one non-similarity with strict hierarchies. A non-strict hierarchy have one level in a hierarchy path to be having only one parent level. However an instance (or member or value) in a level could belong to multiple instances in the parent level.
|
| |
|
|
Multiple path hierarchies have a dimensional level belong to two different dimensional levels. However the criteria of analysis is same across the multiple paths.
|
| |
|
|
Parallel Hierarchies are most flexible hierarchy paths
|
| |
|
|
|
|
|
|
All Chapters in "Data Analysis/OLAP." Section
|
|
|
|
| |
| |
| Back |
|
|
|
|
|
