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
   Multiple Path Hierarchy  

ENCYCLOPEDIA→   Enterprise Intelligence  →   -  Data Analysis/OLAP  →   -  Business Hierarchies in OLAP and Data Warehouse  → 

Parallel Dimensional Hierarchy

Parallel Hierarchies are most flexible hierarchy paths

In parallel path dimensional hierarchy system:

  • Each level in the tree can have more than one possible parent level AND
  • Each instance can belong to more than one instance in the parent dimension level AND
  • Criteria for analysis is different

Sales office—>direct sales Channel Area—>direct sales channel sector—>Direct sales Channel Zone—> Sales Region (Sales organization dimension)

Sales Office—>city—>district—> state—> country (Location Dimension)

If you look at the example, sales office level belongs to two different parent level dimensions (Direct sales channel area and city), the instance of an office (say Sydney harbor office) belong to two different instances (Sydney west sales area and Sydney city) and also different criteria for analysis (sales organization and location).

Essentially the difference between the parallel and multiple hierarchy is on the criteria for analysis.

A parallel hierarchy can be a dependent hierarchy - whereby the paths could be sharing the same levels like the following:

Sales office—>direct sales Channel Area—>direct sales channel sector—>Direct sales Channel Zone—> Sales Region—> Country (Sales Organization Dimension)

Sales Office—>city—>district—> state—> country (Location Dimension)

In the above example, you will have the 'country Level' being shared. Country (like sales office) is also appearing as an instance in two different dimensions

 

   Multiple Path Hierarchy  
 
 

Was this page helpful?
 
Content Additions
 
 
More on Hierarchies in OLAP & DW
OLAP & DW Dimensional Model Hierarchy
Dimensional Model Simple Hierarchy
Dimensional non Strict Hierarchy
Multiple Path Hierarchy
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
Sales Objectives Clarity
Sales Channel Partner Acquisition
Sales Leads Allocation and Distribution
Sales Compensation Structure Decision
Sales facility Infrastructure
Read more...
  Customer Relationship Management
Customer Segmentation Actions
Customer Segmentation approach
Customer Satisfaction & Retention- Data Management
Drivers for Customer Satisfaction & Retention
Customer Service and Support Overview
Read more...
  Human Resources & Leadership
Strategic Business Plan
Deliver Results
Give feedback closer to the observation
Lead diverse and collaborative teams
Fostering Innovation
Read more...
 
 
Business Performance & Planning
SWOT Assessment Report
For important KPIs- Install first & Fix later
Financial Business Plan
Strategy Blueprint Information Gathering
Stakeholder test for Scorecard
Read more...
  Business Intelligence & Data Quality
Data Quality is not Perfect Quality
Data Quality Program Initiation
Data Warehouse ETL Extraction
HOLAP- Hybrid OLAP architecture
A smart manager does not follow-up
Read more...
  IT Vendors & Tools Management
OLAP Architecture Cache Management
Report Delivery Management
enterprise Reporting Server connectivity
OLAP Sever Database Tuning
Multi Layer Architecture
Read more...