Downgrade OBIEE RPD Version

Some times we need to down grade the obiee rpd repository version. I came across this situation, while I'm trying to deploy the .rpd of higher version to lower version of OBIEE.

Before going to deploy the rpd, first check your "Oracle BI Administration Tool" version. Then down grade your .rpd file to that version.

open the administrator and click on help, then click on About Oracle BI Administration Tool.

here you will find your OBIEE version and repository version

Now your rpd file should be equal to this repository version(326), if not you have to downgrade or upgrade the rpd file version.

Open the command prompt as an administrator. use this below command.

Go to <home>oraclebi\orahome\bifoundation\server\bin> nqgenoldverrpd   -P Password -I 'present rpd loaction'  –O 'output rpd location' -V 'required rpd version'.

nqgenoldverrpd : Command for downgrade rpd version.

-P                         : password for rpd file

-I                          : Input file location, that is your current rpd file location.
-O                         : Output file location, that is where you want to place your downgraded rpd file

-V                         : Version number, which is required to downgrade.

Example:

 <home>oraclebi\orahome\bifoundation\server\bin> nqgenoldverrpd   -P Mypass123$

-I D:\rpd\achanta349.rpd  –O D:\rpd\achanta326.rpd -V 326

now you can find the update rpd with repository version 326 at D:\rpd\achanta326.rpd

If you have any question please leave a comment.