Oracle Analytics Cloud and Server Idea Lab

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

Command Line utility to run the Repository Documentation Report

Needs Votes
22
Views
1
Comments

We are using Oracle Analytics Server 6.4 (2022)

In the Oracle BI Admin Tool, you can generate the Repository Documentation Report manually from the Tools > Utilities menu.  

We would like to be able to generate the same report from the command line. 

I've seen posts from many years ago which discuss an unsupported way of doing this for OBIEE 11g and 12c, links here:

https://www.jamescoyle.net/how-to/2022-export-obiee-rpd-documentation-data-lineage-from-the-command-line

https://bivibes.blogspot.com/2015/12/automatic-repository-documentation-in.html

I'm not aware that there is any documented way of doing this in Oracle Analytics, but it would be a great utility to have, because it means we can join RPD metadata to Webcat report data, to give us an end-to-end lineage view of the physical layer through to Webcat objects.

We can then build a subject area over the data for report user consumption.

This would be better still if it were available as a server utility, because it can then be called from ODI and the CSV output immediately loaded into an Oracle table.

Kind regards, Nick

3
3 votes

Needs Votes · Last Updated

Comments