Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Automation for Catalog Manager Reporting

Received Response
43
Views
5
Comments
2907961
2907961 Rank 1 - Community Starter
edited Aug 13, 2024 5:53PM in Oracle Analytics Cloud and Server

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.

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    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

    pastedImage_4.png

    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
    Charles M Rank 6 - Analytics Lead

    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
    Ebin Cherian Rank 5 - Community Champion

    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
    2907961 Rank 1 - Community Starter

    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
    Charles M Rank 6 - Analytics Lead

    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