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

iv. Additional Info

Attachment