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 Compensation System
Lead marketing Database Quality
telemarketing Sales Lead Generation
Enhancing Sales Channel productivity
Sales Synergies
Read more...
  Customer Relationship Management
Customer Value and Profitability- BI
Customer Service and Support Overview
Customer-Centric product-service management
Customer Value and Profitability-Overview
Drivers for Customer Satisfaction & Retention
Read more...
  Human Resources & Leadership
People become the way you treat them
What is Leadership?
Give feedback closer to the observation
Develop Self and Others
Customer Focus
Read more...
 
 
Business Performance & Planning
Stakeholder test for Scorecard
SWOT Analysis in Strategic blueprint Planning
Strategic Planning Business Themes
For important KPIs- Install first & Fix later
Scorecards need manual finish
Read more...
  Business Intelligence & Data Quality
Data Governance Checklist
Data Warehouse is beyond Analytics
Internal capabilities for BI modeling and analysis
Data Warehouse IS-IT assessment
BI Mixed Data Access
Read more...
  IT Vendors & Tools Management
BI Tool Vendor Evaluation
Security Technical Evaluation
Vendor future plans Strategic fit
Vendor Delivery Evaluation Governance
Data Profiling and Monitoring
Read more...