Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Automation of Create report utility of catalog manager

Received Response
51
Views
8
Comments
User_R93U9
User_R93U9 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:52PM in Oracle Analytics Forum

I want a report on analysis and dashboard which shows me what object is placed at which path, which dashboard has what dashboard pages and analysis associated with it. We can do this using create report option in catalog manager. Can we automate that option to run on weekly basis?

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    You could do this using the catalog manager command line interface (CLI)

    Run the below for some details of the runcat report CLI:

    runcat.sh -cmd report -help (unix)

    runcat.cmd -cmd report -help (windows)

    You'll just need to write a script that generates the report and then schedule the script on your server.

  • Charles M
    Charles M Rank 6 - Analytics & AI Lead

    Hi -

    You may want to consider using data lineage.

    What is your version/configuration?

    Regards,

    Charles

  • User_R93U9
    User_R93U9 Rank 3 - Community Apprentice

    OBIEE Version : 11.1.1.9.5

  • Charles M
    Charles M Rank 6 - Analytics & AI Lead

    Thanks ... you using ODI?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Look at what Joel posted: if you can do it in catalog manager then you just need to call catalog managed by command line and generate the same report like that. Schedule that command and done.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    Charles M wrote:Hi -You may want to consider using data lineage.

    What do you call "data lineage" ?

    Isn't that just an OBIA thing?

    Because the thing getting the close to data lineage in OBIEE itself is a bunch of scripts provided in OBIEE Sample App, or there is also a super expensive tool which does the same (but it's really expensive).

  • Charles M
    Charles M Rank 6 - Analytics & AI Lead

    Hi Gianni,

    The approach suggested by Joel seems to be the best fit for what was asked.

    I was just adding some supplementary information to the discussion. I had seen that OBIEE (non-OBIA) had the ability to configure data lineage.

    Here is where I had seen the reference (look towards the bottom of the note for the OBIEE mention ...): Where is the Documentation to Configure OBIA Data Lineage (Doc ID 2277013.1)

    Here is the link to the product documentation: https://docs.oracle.com/middleware/11119/odi/develop-connectivity-km/biee_lineage.htm#ODIKM1496

    Regards,

    Charles

  • Gianni Ceresa
    Gianni Ceresa Mod

    Ah, that thing.

    I guess it always end up being related to OBIA things, so not sure if there would be any extra licensing or not. But still something to check if it works for real or not