nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Automation of Create report utility of catalog manager

User_R93U9

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?

Find more posts tagged with

Accepted answers

All comments

Joel Acha

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

Hi -

You may want to consider using data lineage.

What is your version/configuration?

Regards,

Charles

User_R93U9

OBIEE Version : 11.1.1.9.5

Charles M

Thanks ... you using ODI?

Gianni Ceresa

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

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

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

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