OBIEE Hierarchies Introduction Part-1

• A hierarchy is a cascaded series of many-to-one relationships and consists of different levels.
• OBIEE Supports Level based Hierarchy, Parent child Hierarchy

Level based: Consists of one or more levels. Each level in hierarchy is different column in the Dimension table

Ex: Time Dimension contain Year, Quarter, Month, Day

Table Structure:

Value based: Consists of values that define the hierarchy, rather than levels.

Ex: Employee Dimension Contain employee name and his manager ID, Manger Id creates the hierarchy

Table Structure:

Types of Hierarchies:

1. Balanced Hierarchy: All of the dimension branches have the same number of levels.

Ex: Time Dimension

2. Ragged Hierarchy: Dimension branches containing varying numbers of levels.

Ex: Organization Chart

3. Skipped Hierarchy: A ragged dimension contains at least one member whose parent belongs to a hierarchy that is more than one level above the child.

Ex: Geography Dimension