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

RPD Documentation through BI Server

Received Response
42
Views
4
Comments
Sravan Gereddy
Sravan Gereddy Rank 3 - Community Apprentice
edited Aug 13, 2024 6:02PM in Oracle Analytics Cloud and Server

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    Sravan Gereddy Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 2 - Community Beginner

    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
    Joel Rank 8 - Analytics Strategist

    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"