RPD Documentation through BI Server

Sravan Gereddy

Hey,

So we have a requirement to create reports on BI Metadata (Catalog and RPD). Our strategy is to automate and generate two csv files, one for catalog meteadata and the other for RPD and load data into tables. Once done, we expose them into RPD and build reports. 

We are able to automate the process of catalog metadata, but facing problems for RPD documentation. As RPD Documentation is a feature of BI Admin tool, we are having hard time to generate the RPD Documentation through server. Is there any way, we can generate RPD documentation through BI server in csv format? Scripts like ./biserverxmlgen.sh do help in getting metadata info in XML format, but there is no such script for csv.

Please let me know if there any approach.

Version : 12.2.1.1.0

Thanks,

Sravan

[Deleted User]

What you are looking for are admintool.exe commands. WARNING: Their usage is NOT officially supported!

Anyone reading this thread and messing up things....it's your own fault. you've been warned.

Once more: Unsupported! Your mess-up. Your problem.

Now that this is out of the way and whining script kiddies have been warned thrice:

admintool.exe /command /stuff/myrpddestructioncommands.txt

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

myrpddestructioncommands.txt

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Open someofflinerpd.rpd Username Password

Hide

DescribeRepository /stuff/rpd_as_csv/current_rpd.csv UTF-8

GenerateMetadataDictionary /stuff/mdd

Close

Exit

Sravan Gereddy

Thanks for the approach. I've already come across this, but this approach is something which we do from local machine. I'm looking for some way that can be don at BI server level itself. Like, instead of using the Catalog Manager client tool, I can generate the catalog metadata using ./runcat.sh script(in BI server). Looking for something similar.

[Deleted User]

Ok so just to be explicit once more: those are Admin Tool functions.

Admin Tool is Windows-only unless you use Borkur's approach with wine ( @Andrew Fomin. also wrote sth but can't find it anymore...what's up with that Andrew??)

There is no "something similar" unless you push the MDS XML into your database

Joel

You could use the Oracle BI Server XML API - biserverxmlgen

About the Oracle BI Server XML API

This generates an XML output file.

"The Oracle BI Server XML schema document (xudml1.xsd) contains the grammar for the structure of XML repository files. You can find this file at: ORACLE_HOME/bi/bifoundation/server/bin"