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
   OLAP and Data Warehouse Dimensional Model Hierarchy Dimensional non Strict Hierarchy  

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

Dimensional Model Simple Hierarchy

Simple or strict hierarchy is the simplest form of business Hierarchies.

Symmetric Hierarchy is the simplest form of a simple hierarchy. It has:

  • All levels in the hierarchy must exist.
  • There in only one path from bottom most to top. In other words, a level cannot exist in any other hierarchy.

For example- you will not have city in any other hierarchy path. Simple example- is the same ' Office—> City—> State—> Country—> Continent—> Globe'

Asymmetric Hierarchy

Asymmetric hierarchy will be same as that of symmetric hierarchy apart from the fact that, you may not have lower levels existing in some instances. Let's take an example of Sales Channel. In this you may have

3rd party sales agent—>Sales Executive—>Sales Manager—>Sales Area —>Sales Zone—>Sales Region

In the above, for certain instance, it might be possible that a 3rd party sales agent may not exist and the sale is directly done by the sales executive. Therefore there will be nil instances for lowest level in this hierarchy in certain cases.

Generalized hierarchy:

In generalized hierarchy, there may be shared levels within the two different hierarchy paths, but an instance at lower level, cannot belong to two instances in the parent. For example

3rd party sales agent—> Sales Executive—>Indirect Channel--Sales Manager—>Sales Area Manager—>Sales Zone head—>Sales Region head

Sales executive—>direct Channel--Sales Manager—>Direct Channel-Sales Area manager—>Sales Zone head—>Sales Region head

In the above two cases you have shared level at 'Sales Executive', 'Sales Zone' and 'Sales Region'. However, any instance of sales executive will belong to only one parent- Either to an Indirect Channel -Sales Manager OR Direct Channel- Sales Manager. In other words, If a sales executive is working for two managers (one direct and one indirect), it will not be a simple hierarchy.

Non-covering hierarchy

In this hierarchy, an instance of an intermediate level may be missing. For example, in the below hierarchy,

Sales executive—>direct Channel--Sales Manager—>Direct Channel-Sales Area manager—>Sales Zone head—>Sales Region head

For some instances, you may have a direct sales Manager directly reporting to sales zone head as the zone might be smaller and the sales area manager level may not be existing in that zone.

 

   OLAP and Data Warehouse Dimensional Model Hierarchy Dimensional non Strict Hierarchy  
 
 

Was this page helpful?
 
 
More on Hierarchies in OLAP & DW
OLAP & DW Dimensional Model Hierarchy
Dimensional non Strict Hierarchy
Multiple Path Hierarchy
Parallel Dimensional 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 Channel Mix Profitability
Sales Behavior
Sales Campaign SWOT analysis
Sales Compensation components
Sales Campaign Business Intelligence
Read more...
  Customer Relationship Management
Customer Segmentation Actions
Customer Value and Profitability-Overview
Customer Satisfaction and Retention- Overview
Customer Service and Support - Strategic Role
Customer Satisfaction & Retention- Data Management
Read more...
  Human Resources & Leadership
Deliver Results
Customer Focus
People become the way you treat them
Developing Leaders- Few Leadership Traits
Act with Decisiveness
Read more...
 
 
Business Performance & Planning
Creating Strategy Blueprint
Strategy Blueprint Information Gathering
Strategy Map to Strategic theme
A KPI should be simple -but it depends
External Info Assessment Report
Read more...
  Business Intelligence & Data Quality
Data Warehouse Business Requirements
OLAP what if Analysis
Data Warehouse Data Quality assurance
BI & Data Warehouse- End User Tools
OLAP and Data Warehouse Dimensional Hierarchy
Read more...
  IT Vendors & Tools Management
OLAP Server write backs
Data explosion OLAP Server
Vendor Evaluation Conversion effort
Technical Evaluation- Interoperability
Security Technical Evaluation
Read more...