Friday, January 18, 2013

[OBIEE11g] - Command Line Merging in OBIEE 10g/11g

Problem
How to do merge in OBIEE 10g/11g using Command Prompt.

Solution
i.  Description
Script will be helpful in OBIEE Merging using command line utility. 
Script will take Source RPD ,Username and Password for Source RPD as input and generate script and Merged RPD as Output.

ii. Procedure
1. Goto Start -> Run
2. Type cmd on Open textbox.
3. Press OK to open command prompt.
4. Use the code snippet in Code section.

iii.Code
For OBIEE 10g

nQUDMLGen.exe -U Administrator -P nipperso -R "C:\Desktop\Corp-Merging-SSA-13Sep\Corp-dev\CORP_DEV.rpd" -O "C:\Desktop\Corp-Merging-SSA-13Sep\Corp-dev\CORP_DEV.txt" -N

nqudmlexec.exe -U Administrator -P nipperso -I "C:\Corp-Merging-SSA-13Sep\Corp-dev\CORP_DEV.txt" -B "C:\Corp-Merging-SSA-13Sep\Corp-stg\CORP_STG.rpd" -O "c:\Corp-Merging-SSA-13Sep\Corp-stg\CORP_STG_SSA_MERGED.rpd"

FOR OBIEE 11g

nQUDMLGen.exe -P analytics02 -R D:\Merging\21feb\Trimmed_Analytics02_Merged_BI0018_INC000002682719.rpd -o D:\Merging\21feb\op1.txt

nqudmlexec.exe -P analytics02 -I D:\Merging\21feb\op1.txt -B D:\Merging\21feb\CIDCDEVHA_BI0024.rpd -o D:\Merging\21feb\CIDCDEVHA_BI0024_Merged.rpd