2.4.6.1.3.1 Create and Refresh Parent/Child Hierarchy Data

OBIEE RPD is enhanced to read the data of hierarchies from database. This is achieved using views in database so that data is pre-prepared before OBIEE layer needs it. Use the Run pipeline (process) Reporting Parent Child Relation Data Population to create and refresh parent/child hierarchy data.

Note:

This pipeline must be executed even after completing the custom pipeline with SCD and connector data population.

To use and execute the Reporting Parent-Child Relation Data Population process within Process Orchestration, follow these steps:

1. On the home page, select the Process Orchestration. The Process Modeller page is displayed.
2. To execute the run, follow these steps:
   1. Navigate to the Process Flow page or the Process Modeller page.
   2. Select the Run Parameter Values using the Execution button.
   3. On the Process Modeller page, locate the Reporting Parent-Child Relation Data Population process.
   4. Click the Menu button corresponding to the process you want to execute.
   5. Click Execute Run. The Execution Page will be displayed.
   To execute a run with parameters on the Execution page, follow these steps:
   1. In the Execution Type list, select With Parameters.
   2. Choose the required As of Date for which the SCDs need to be processed.
   3. Select NA as the Data Source option.
   4. Click Execute to initiate the Run Pipeline execution.