OBIA 11g: Unable To Extract Metadata for OBIEE RPD Using Catalog Manager For Setup of Data Lineage (Doc ID 1916193.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

Two situations:

Situation 1: Scripts not available in Linux

After the installation of OBIA 11g on a Linux environment using the Oracle® Business Intelligence Applications Administrator's Guide for Data Lineage Configurations. Unable to execute task to complete setup before loading Data Lineage dashboards in OBIA 11g. While BI APPS (OBIA) is installed on Linux platform the documentation states to execute a batch script to extract metadata on Windows environment. Looking for the same on the Linux environment, there are nowhere to be found.

Here are the steps to take found in the Documentation: 6.4.1 Extracting Oracle Business Intelligence Metadata Using Scripts

It states to copy and execute the following scripts on windows environment where OBIEE is installed.

  1. webCatExtract_dashboard
  2. rpdExract
  3. webCatExtract

These scripts will generate extracted metadata files, webcat_text.txt and webcat_dashboard_test.txt and they will be finally used from Load Plan to populate tables for Data Lineage Dashboards.

 

Situation 2: Not all columns exist in "Dashboard"

When using MS Windows x64 client catalog manager 11g to create report files webCat_dashboard_text.txt to be used as data source for the predefined Load Plan Data Lineage for OBIA. At step 4 in "Extracting the Dashboard Metadata" in "Extracting Oracle Business Intelligence Metadata Using Catalog Manager and Administration Tool" in Oracle® Business Intelligence Applications Administrator's Guide 11g: Researching Data Lineage http://docs.oracle.com/cd/E63231_01/doc/BIASA/GUID-7C5492C6-CB1A-417B-B7DA-1C9FA00B38F1.htm#GUID-B726EDF8-52D9-43A7-90AB-D0C457A78B7C. Instructions state to select "Dashboard" then columns: Owner, Folder, Name, Path, Dashboard Style which do exist in the list; but columns Dashboard Page Name, Dashboard Page Path, Analysis Name, Analysis Path do not exist in the list.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms