Unbalanced Hierarchies(Ragged and Skipped)

Unbalanced Hierarchies(Ragged and Skipped):

1.38073 - Dimension ‘@1%ls‘ has multiple leaf levels which are not  identical?

A) This error occur when the Leaf levels in a dimension have to be identical.But also when you have metadata problem. You get them by using “Create a parent level” from a leaf level. Try to use “Create a child level” from the Grand Total level.

2) What is Ragged and Skipped Hierarchies?

A) Ragged Hierarchies:

The number of levels in all the branches of a hierarchy are not equal. All child nodes/lowest nodes are not at the same level, one or more of the nodes are in a higher level.

b. Skipped Hierarchies:

The number of levels between a parent node and a child node in a branch is more than one. In other words, a few levels are skipped between the parent node and child node.

3) What is Level based Hierarchy?

A) Level-based Hierarchy:

Consists of an ordered set of two or more levels For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships.

a. Level-based Dimension hierarchy levels allow :

• To perform aggregate navigation,
• To configure level-based measure calculations,
• Users from Dashboard and Answers to drill down from one parent to a child level.

Special type of level-based dimension is supported:

• Unbalanced (or ragged) and Skip-level hierarchy
• Time dimension to provides special functionality for modeling time series data.

4) How to handle the NULL Values problems?

A) In case of Ragged we cannot define fixed number of levels as for certain rows don’t have all the levels.

1. In case of skip level again we have to handle the NULL values in between levels which lead to removal of the row which is part of the skip level and won’t be displayed in the output.

OBIEE 11g has a way to handle NULL problems easily.

1. It’s just we have to mark those dimensions as Ragged or Skipped level and rest will be taken care of.

5) How to identify if parent have no child ?

A)“Whenever parent and child values are same, that means there is no child.”