In command prompt move to the following location,
BI_HOME\bifoundation\server\bin
Eg:
D:\OBIEE_HOME\Oracle_BI1\bifoundation\server\bin
Then use the below command
nQUDMLGen.exe -p XXX -R Trimmed_RPD_PATH -o Trimmed_RPD_Txt_FILE_PATH
Eg:
nQUDMLGen.exe -p Admin123 -R D:\merge\Trimmed.rpd -o D:\merge\Trimmed.rpd.txt
nqudmlexec.exe -P Admin123 -I Trimmed_RPD_Txt_FILE_PATH -BMAIN_RPD_PATH -o Merged_RPD_PATH
BI_HOME\bifoundation\server\bin
Eg:
D:\OBIEE_HOME\Oracle_BI1\bifoundation\server\bin
Then use the below command
nQUDMLGen.exe -p XXX -R Trimmed_RPD_PATH -o Trimmed_RPD_Txt_FILE_PATH
Eg:
nQUDMLGen.exe -p Admin123 -R D:\merge\Trimmed.rpd -o D:\merge\Trimmed.rpd.txt
nqudmlexec.exe -P Admin123 -I Trimmed_RPD_Txt_FILE_PATH -BMAIN_RPD_PATH -o Merged_RPD_PATH
Eg:
nqudmlexec.exe -P Admin123 -I D:\merge\Trimmed.txt -BD:\merge\Main.rpd -o D:\merge\Merge.rpd
Merge.rpd is the final merged RPD. This will help for a quick merge...
Awesome post Hari
ReplyDelete