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 Data Management
Sales strike rate
Sales Behavior
Sales geographic expansion
Sales Revenue SWOT
Read more...
  Customer Relationship Management
Customer Service and Support Overview
What is Customer Segmentation?
Supply Chain for Customer Service and Support
Customer Value and Profitability Tips and Actions
Customer-Centric product-service management
Read more...
  Human Resources & Leadership
Leadership Development- Setting the Context
What is Leadership?
Developing Leaders- Few Leadership Traits
Develop Self and Others
Lead Change
Read more...
 
 
Business Performance & Planning
Creating Strategy Blueprint
Strategic Vision and Mission
Strategic Planning leadership commitment
Strategy Blueprint Information Gathering
For important KPIs- Install first & Fix later
Read more...
  Business Intelligence & Data Quality
Object Level Data Quality Tracking
Data Warehouse job control and audit
Data Map & Assessment Report
Knowledge Discovery in Databases Program
Data Quality Program Approach
Read more...
  IT Vendors & Tools Management
OLAP Server administration
Report Development for Enterprise Reporting
Multi Layer Architecture
Metadata Tool Change Management
OLAP Server Reliability
Read more...