• Each individual in the organization is an employee.
• Each employee, apart from the top-level managers, reports to a single manager.
• The reporting hierarchy has many levels.
In relational tables, the relationships between different members in a parent-child hierarchy are implicitly defined by the identifier key values in the associated base table. However, for each Oracle BI Server parent-child hierarchy defined on a relational table, you must also explicitly define the inter-member relationships in a separate parent-child relationship table.
To create a logical dimension with a parent-child hierarchy, perform the following steps:
- Open the Repository in Offline Mode
- Import Metadata and Define Physical Layer Objects
- Create Logical Table and Logical Columns
- Create a Logical Join
- Create a Parent-Child Logical Dimension
- Define Parent-Child Settings
- Create Presentation Layer Objects
- Test Your Work
|1 .||Return to the Administration Tool, which should still be open. If not, select Start > Programs > Oracle Business Intelligence > BI Administration.
|2 .||Select File > Open > Offline.
|3 .||Select BISAMPLE.rpd and click Open.
Do not select any BISAMPLE repository with an extension, for example,
BISAMPLE_BI0001.rpd. Recall that these are the repositories that have
been loaded into Oracle BI Server memory.
|4 .||Enter BISAMPLE1 as the repository password and click OK to open the repository. |