5.6.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 has to be executed even when custom pipeline with SCD and connector data population is complete.

To use and execute the Reporting Parent Child Relation Data Population process in the Process Orchestration, perform the following:

1. On the Home page, select the Process Orchestration. The Process Modeller page is displayed.
2. To execute the Run, you can select the Run Parameter Values using the Execution button on the Process Flow page or on the Process Modeller page.
   Navigate to the Process Modeller page and click the Menu button corresponding to the Reporting Parent Child Relation Data Population process that needs to be executed. Click Execute Run. The Execution Page is displayed.
3. On the Execution page, to execute Run with parameters, select With Parameters in the Execution Type List. Select the required As of Date for which the SCDs need to be processed. Select the Data Source as NA option and click Execute to initiate the Run Pipeline execution.

   Note:

   The execution of the Run Pipeline is triggered using the selected Extraction Date.

   Note:

   Once the execution is complete, the hierarchies are displayed in the BCE Subject Area.