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.
- 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, ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
