Thursday, May 10, 2012

OBIEE 11g RPD to XML

biserverxmlgen:

RPD -> XML

Syntax:
E:\Middleware\Oracle_BI1\bifoundation\server\bin>biserverxmlgen
biserverxmlgen  [-P repository_password] -R repository_pathname -O output_script_pathname [-8] [-N] [-Q] [-S]
  -8                 is for UTF-8
  -N                 is for not generating upgrade id
  -Q                 is for generating script without security objects
  -S                 is for generating script for only security objects
                     Q and S override each other if both are present
  -H -?              Display this usage information and exit.


Worked Example:
E:\Middleware\Oracle_BI1\bifoundation\server\bin>biserverxmlgen -P Admin123 -R in.rpd -o out.xml.txt
XUDML generation was successfull.
E:\Middleware\Oracle_BI1\bifoundation\server\bin>


biserverxmlexec:

XML -> RPD

Syntax:
E:\Middleware\Oracle_BI1\bifoundation\server\bin>biserverxmlexec

Usage:
    biserverxmlexec   [-P <pwd>] {-I <script1> [-I <script2> -I <script3>]} [-B
<baseRpd>] -O <outputRpd> [-E]

Options:
    -P      : Password for repository
    -I      : Input script file name
    -B      : Base repository name
    -O      : Output repository name
    -E      : Exit without creating the RPD
              if an expression parsing error occurs
    -h      : Display this usage information and exit

Examples:
    biserverxmlexec -P passwd -I xudml.xml -O rp1.rpd
        Create a new repository rp1.
    biserverxmlexec -P passwd -I xudml1.xml -I xudml2.xml -O rp1.rpd
        Create a new repository rp1 using multiple XUDML files.
    biserverxmlexec -P passwd -I xudml.xml -B rp1.rpd -O rp2.rpd
        Modify rp1 and write to rp2.


Worked Example:


E:\Middleware\Oracle_BI1\bifoundation\server\bin>biserverxmlexec -P Oracle123 -I
 out.xml  -o pbirpt_changed.rpd

---------------Complete Success!!---------------

E:\Middleware\Oracle_BI1\bifoundation\server\bin>

2 comments:

  1. Hi,

    I have a requirement to generate OBIEE Repository (RPD) file out of XUDML (XML) file.
    I am generating XML file based on the metadata available in OFSAA product and it is happening at the WEB layer which is deployed on the different physical machine.

    Questions:

    Do we have any API available in OBIEE, which I can call it from my WEB page?
    Do we have any web services in OBIEE (which is exposed to the external world) where I can pass my XUDML document and generate RPD out of it?
    Can I copy some jars (which used to generate RPD) out of OBIEE deployed area and bundle in my product EAR file? If yes, can I call RPD generation utility directly in my WEB and what is the class/method name with parameters I have to pass?

    I am having problem in communicating between two different application (my project & OBIEE).

    Please help me with this.

    ReplyDelete