Refresh the Catalog Lineage Metadata

If the Oracle Healthcare Foundation SSA Dashboards have been extended, follow the instructions below to refresh the RPD lineage metadata:

1. Open the Command Prompt.
2. Navigate to the to bi\bitools\bin subdirectory in the Oracle Business Intelligence Client Tool installation directory. For example:

   cd C:\Install\middleware\BI_Home\bi\bitools\bin

3. Create a .txt file with the Oracle WebLogic Server credentials in the following format:

   login=username
   pwd=password

4. Execute the following command:

   runcat.cmd -cmd report -online BI Analytics URL where the dashboard catalog contents reside -credentials Path to the credentials file containing the weblogic user name and password -outputFile Path to the output file with extension .csv where the catalog metadata contents have to be stored -folder Location of the OBI Catalog Folder -delimiter "|~" -type "Analysis" -fields "Owner:Folder:Name:Path:Subject Area:Table:Column:Formula"

   For example:

   runcat.cmd -cmd report -online http://obixxx.mycompany.com:9504/analytics/saw.dll? -credentials D:/login.txt -outputFile D:/ohf_hcd_catalog.csv -folder "/shared/Oracle Healthcare Foundation" -delimiter "|~" -type "Analysis" -fields "Owner:Folder:Name:Path:Subject Area:Table:Column:Formula"

5. After completion, a success message is displayed:
   Making SOAP connection to http://obixxx.mycompany.com:9504/analytics/saw.dll? Running Report..4..3..2..1..0..Done!
6. Open SQL Developer.
7. Connect to the Oracle Healthcare Foundation Enterprise Schema where the OHF_CATALOG_LINEAGE table is installed.
8. Expand the Tables section.
9. Right click on the OHF_CATALOG_LINEAGE table and select Import Data.
10. In the File browser, navigate to the location where the Catalog Metadata File is saved.
11. Choose the .csv file type and select the Catalog Metadata file.
12. Click Open.
13. When prompted to Import Data Record Terminator, click OK.
14. When prompted to Import Data Field Format, click OK.
15. In the Data Import Wizard, select the delimited format.
16. Set the Delimiter to |~.
17. Set the Left Enclosure to none.

    Figure 4-5 Data Preview

    
18. When prompted to Import Data Field Format, click OK.
19. Click Next.
20. In the Import Method screen, click Next.
21. In the Selected Columns pane, make sure all columns are listed and click Next.
22. In the Column Definition screen, map all the source data columns to the target table columns. The source and target columns have similar names and can be matched either by name or by order.

    Figure 4-6 Column Definition

    
23. After you map all the columns, click Next.
24. Click Finish.
25. A data import progress screen is displayed.
26. After the import is complete, a success message is displayed. Click OK.
27. Query the OHF_CATALOG_LINEAGE table to retrieve the record count and compare it with the row count in the Catalog Metadata file:

    Select count(*) from OHF_CATALOG_LINEAGE;