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>

Thursday, April 19, 2012

Navigate to Different Dashboard retaining current Session Params

Tested OBIEE 11g 11.1.15.0

Function to use: 
PortalPageNav(event,'<Complete Path to Dashboard>','Page Name')

Working example :
"<span onclick="javascript:PortalPageNav(event,'/shared/Attach Rate TD/_portal/3Attach Rate (Teradata)','Sales View - Detail')" class="Nav"><u> @1</u></span>[br/][br/]</span>"

Where:
To be included in Narrative



Monday, February 6, 2012

Hiide export Functionality on OBIEE 11g

Q: What will I Achieve?
A: By default OBiee 11g download feature permits PDF, MHTML, CSV, etc; but we cannot hide / unhide select features, we hide using a java script.

Steps
1. Create a text box on the problem Dashboard..
2. copy paste + Modify code below
" -------| CODE |--------- "

Before:











After: