Tasks for Loading and Refreshing Data Lineage Dashboards

Perform these tasks for initial and ongoing loading and refreshing of data lineage dashboards and their required metadata.

Note:

You must perform the tasks in this section in the sequence described in Setting Up Data Lineage.

Topics:

Extracting Oracle Business Intelligence Metadata Using Catalog Manager and Administration Tool

Extract Presentation Catalog (webcat) and repository (RPD) metadata into files sourced during load of the Data Lineage warehouse tables.

Prerequisities:

OBIEE 11.1.1.6.0 and 11.1.1.7.0 client installations on a Windows machine are a prerequisite to extract OBIEE metadata.

You use Windows-based OBIEE clients from release 11.1.1.6.0 or 11.1.1.7.0 to generate the following files:

  • webCat_dashboard_text.txt

  • webCat_ text.txt

  • rpd_text.txt

Extracting the Dashboard Metadata

Extract the dashboard metadata.

  1. Open Oracle Business Intelligence Catalog Manager 11.1.1.6.0 and connect using a connection type of online to the Oracle Business Intelligence Server, URL: http://Host:port/analytics/saw.dll.
  2. Select Tools, then Create Report.
  3. In the Create Catalog Report dialog box, select Dashboard in the Select type to report on drop-down list
  4. In the Available Columns list, select the following columns and arrange them in order.

    • Owner

    • Folder

    • Name

    • Path

    • Dashboard Page Name

    • Dashboard Page Path

    • Dashboard Style

    • Analysis Name

    • Analysis Path

    Note:

    The column order must be as above.

    Description of GUID-6D46654D-4501-4B4C-B23B-0AFCA9E081C6-default.gif follows
    Description of the illustration GUID-6D46654D-4501-4B4C-B23B-0AFCA9E081C6-default.gif
  5. Click OK.

    It will take few minutes to generate the report. Click OK if an Error window pops up after few minutes.

  6. Save the file as webCat_dashboard_text.txt in a local folder.

Extracting the Report Metadata

Extract the report metadata.

  1. Select Tools, then Create Report.
  2. In the Create Catalog Report dialog box, select Analysis in the Select type to report on drop-down list.
  3. In the Available Columns list, select the following columns and arrange them in order.

    • Owner

    • Folder

    • Name

    • Subject Area

    • Table

    • Column

    Note:

    The column order must be as above.

    Description of GUID-998B5DB3-29CD-4399-8EB4-ED43DD68E9CB-default.gif follows
    Description of the illustration GUID-998B5DB3-29CD-4399-8EB4-ED43DD68E9CB-default.gif
  4. Click OK.
  5. Save the file as webCat_text.txt in a local folder.

Extracting the RPD Metadata

Extract the RPD metadata.

  1. Open the BI Applications RPD using the 11.1.1.7.0 release of Oracle BI Administration Tool.
  2. Select Tools, then Utilities.
  3. In the Utilities dialog box, select Repository Documentation and click Execute.
  4. In the Save As dialog box, save the file as rpd_text.txt.

    Select Tab Separated Values (*.txt) in the Save as Type drop-down list

    Description of GUID-23E1D558-F3C2-4A6F-B464-637E7C785241-default.gif follows
    Description of the illustration GUID-23E1D558-F3C2-4A6F-B464-637E7C785241-default.gif

Copying to the $DL_HOME Directory

In this step, you copy the metadata source files from the local directory on the Windows machine you saved them on to the Data Lineage home directory, where they can be sourced by the Data Lineage Extract and Load load plan. You also copy a Fusion EAR file from its installation location to the Data Lineage home directory.

  1. Copy the webCat_dashboard_text.txt, webCat_ text.txt, and rpd_text.txt from the local directory on the Windows machine to $DL_HOME.
  2. Copy Fusion EAR files from $ORACLE_BI_HOME/biapps/DataLineage to $DL_HOME.

Executing and Monitoring the Data Lineage Load Plan

Execute the Data Lineage Extract and Load load plan in ODI. This load plan uses the sources and extracted metadata files you have configured and generated as sources to load and refresh the prebuilt data lineage warehouse tables.

  1. In the ODI Studio Designer Navigator, expand Load Plans and Scenarios, Predefined Load Plans, then Data Lineage.
  2. Execute the DataLineage Extract and Load load plan, and monitor its execution using the Operator.