Hierarchies in OBIEE 11G
The Hierarchies in OBIEE basically consists of 2 types
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