Oracle Analytics and AI

Automation for Catalog Manager Reporting

I am following this document on how to setup Data Lineage in OBIEE. Section 6.4.1 shows steps to manually create a report to run via the Catalog Manager. Does any one have any examples of a way to automate the creation of a report like this? It seems very cumbersome to have to create this report anytime there is a web catalog change and would like a way to create a report via specified parameters and exported to a directory.

Find more posts tagged with

Accepted answers

All comments

Charles M

Hi -

I'm not sure if you have completed this yet, but make sure you use a 11.1.1.7.0 or 11.1.1.6.0 Catalog Manager client. I have an 11.1.1.9.0 client, and it does not work since it is missing some of the required columns are missing. This is is known issue/bug.

In the Available Columns list, select the following columns and arrange them in order.

Owner

Folder

Name

Path

Dashboard Page Name -- MISSING

Dashboard Page Path -- MISSING

Dashboard Style

Analysis Name -- MISSING

Analysis Path -- MISSING

OBIA 11g: Unable To Extract Metadata Using Catalog Manager For Setup Of Data Lineage (Doc ID 2194309.1)

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

Regards,

Charles

Charles M

By the way ... are you using OBIA (e.g. Bi Applications)? That documentation is referencing OBIA 11.1.1.8.x.

Depending on which version/application/configuration you have, you can try looking at this: https://docs.oracle.com/middleware/11119/odi/develop-connectivity-km/biee_lineage.htm#ODIKM1524

Regards,

Charles

Ebin Cherian

Hi,

We use below mentioned command to track the catalog changes. We include this command in a script and scheduled that script and send output to desired location.

CALL C:\OBIEE_12C_CLIENT\bi\bitools\bin\runcat.cmd -offline "C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bifoundation_domain\bidata\service_instances\ssi\metadata\content\catalog" -cmd report -outputFile "C:\Backups\Catalog_Extract_Reports\Prod_WebCatalog_Extract_%Current_date%.txt" -folder / -distinct -type All -fields "Name:Path:Folder:Creator:Modifier:Created:Modified" -childrenType "Dashboard Page:Analysis" -childrenFields "All"

2907961

Yes, we are running BIAPPS 11.1.1.9. Thank you for your answers and articles. I will review them and give them a try.

Charles M

Hi -

You are welcome.

To get the 11.1.1.7.0 client, go to: https://edelivery.oracle.com, and search for 'Oracle Business Intelligence Developer Client Tool 11.1.1.7.0'

Regards,

Charles