Skipped and Ragged Hierarchies

Hierarchies in OBIEE 11G




The Hierarchies in OBIEE basically consists of 2 types

1. Time Series Hierarchies(For time sieries hierachiy please click on the link)
2.Skipped and Ragged Hierarchies




To take an initial example, suppose we have a dimension of a company Sales Team with company,Region,Offices and Sales People in a form of Hierarchy.




If this was a simple, level-based balanced hierarchy, all would be straightforward. However imagine that this hierarchy was in fact ragged, with only certain offices having sales people. In this case, the leaf levels for the hierarchy wouldn’t be at the same level, something that would have caused problems for RPD modellers working with OBIEE 10g.

Now in 10g this would have been tricky, as OBIEE would have expected each leaf member to be at the same (in this case, concession) level, and if they weren’t, you’d need to fudge the data a bit, for example by adding dummy concession members so that each leaf was at the same level.
Going back to our hierarchy, another interesting thing you often get in real life is “skip levels”. Imagine that some of our Sales People  are so important that they report directly to the regional office, with no offices in between. 
In the diagram below, the sales person DEEPAK  reports directly to the Dubai  regional office, and again in 10g you’d need to create a dummy store parent for this concession to make it all work. This is an example of Skipped Hierachy
while in the diagram there is no Sales Person in the region Nigeria and again if it was in 10g we had to create a dummy value to accommodate this hierarchy. This is an example of Ragged Hierarchy

OBIEE 11g can handle this though with the new ragged and skip-level support for level-based hierarchies. It does this by detecting NULLs in either leaf levels (for ragged hierarchies) or other levels (for skip-level hierarchies) and use this to modify how the new hierarchical column type in Answers handles the missing levels. To create a ragged and/or skip-level hierarchy, you would therefore import your source schema into the OBIEE 11g physical layer as normal, and then create the logical model in the business model and mapping layer, like this:

Steps to create a Skipped and Ragged Hierarchies

 1. This is a normal Hierarchy as that of Time Based Hierarchy. To create a Hierarchy please visit my the post below

   Time Series Hierarchies

2. In the Skipped and Ragged Hierarchy make sure you tick the box mentioned below.





3. Once the Hierarchy is created it should look something like this.



4. After this pull it into the Presentation Layer and view it in the Analysis.


For time series hierarchy please click on the link below
http://obieegyan.blogspot.com/2012/10/how-to-crete-time-series-level-based.html


Cheers !!!
Jethin Abraham



Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s