Creating multi-table hierarchies
Hierarchies are not always restricted to a single table and may span across multiple tables. For this reason, OBIEE supports the ability to create hierarchies across multiple tables.
Getting ready
In the BI Administration tool, ensure all the source tables are imported and are joined together correctly.
How to do it...
In many cases, hierarchies may span across multiple tables. OBIEE has the capability to create hierarchies across multiple tables, thus reducing the need to create additional physical objects:
- Ensure there are joins between the tables you wish to create a hierarchy upon. These should be inner joins.
- In the Business Model and Mapping layer, create a new logical table and base it on a single table:
- Select ...
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.
