|
|
|
|
|
Execution-MiH ENCYCLOPEDIA →
Enterprise Intelligence →
SECTION - Data Analysis/OLAP →
|
CHAPTER -
| Business Hierarchies in OLAP and Data Warehouse |
|
The subject of hierarchies is relevant to both OLAP and Enterprise Intelligence 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
|
|
OLAP and Data Warehouse Dimensional Model Hierarchy
|
The subject of hierarchies is relevant to both OLAP and Execution-MiH 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.
|
| |
|
Dimensional Model Simple Hierarchy
|
Simple or strict hierarchy is the simplest form of business Hierarchies.
|
| |
|
Dimensional non Strict Hierarchy
|
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 Hierarchy
|
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 Dimensional Hierarchy
|
Parallel Hierarchies are most flexible hierarchy paths
|
| |
|
|
|
|
|
|
|
All Chapters in "Data Analysis/OLAP." Section
|
|
|
|
| |
| |
| Back |
