Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Skip Level Hierarchy

A skip level hierarchy is a level based hierarchy, but some of levels are skipped.

In a level based hierarchy, the hierarchy is built based on the levels.  A level is a collection of nodes.  The relationship between levels is hierarchical.

We can say a level is a parent level of another level.  That means that the node in a child level will have a parent node from the parent level.

A skip level hierarchy refers to a hierarchy that include nodes that belongs to a parent node that does not come from the immediate parent level.  The node is directly associated with a parent node that from the grandparent level or above.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s