Developing level-based hierarchies
Hierarchies allow a person to start analyzing information from a summary level with the capability to expand nodes to gain additional details. They are an efficient way to give the user a lot of flexibility and control to view and understand the information.
Getting ready
Open the BI Administration tool.
How to do it...
Hierarchies comprise two main types within OBIEE, namely, Level-Based and Parent-Child. A level-based hierarchy has predefined levels and depth within the hierarchy, which are consistent. Parent-Child is a recursive hierarchy with no set levels or depth.
1. Identify all your tables and join them correctly, based on the key columns within the business model and mapping layer. If this is not done correctly, then the option to create a Dimension object will not exist.
2. Create your dimensions by right-clicking on the tables, and selecting New Object | Dimension with Level-Based Hierarchy:
3. Map your columns as normal.
4. In the properties of...
