OBIEE 11G Version Downgrade

How to Downgrade Repository:

    There is repository downgrade utility nqgenoldverrpd available to downgrade repository version. Using this utility you can downgrade repository from one version to another 11g version. But you cannot downgrade the repository from 11g to 10g.

Path:

• On Server - $MW_HOME/bifoundadtion/server/bin
• On Client - <OBIEE_Client>\Oraclebi\orahome\bifoundation\server\bin

Syntax:

nqgenoldverrpd -P <RPD-Password> -I <Latest version RPD file name & path> -O <Downgrade version RPD file name & path> -V <Version you want to downgrade>

Note:

 -P         - Your RPD password

 -I          - Repository path & name

 -O        - Downgrade new RPD path & name

 -V         - Version you want to downgrade

Example:

In our case we have downgrade from 11.1.1.7.1 to 11.1.1.7.0

11.1.1.7.1 - 326

11.1.1.7.0 - 325

Command Prompt:

C:\Program Files\Oracle Business Intelligence Enterprise Edition plus client tools\oraclebi\orahome\bifoundation\server\bin>nqgenoldverrpd -P Admin123 -I C:\RPD\New\Oracle_Analytics.rpd -O C:\RPD\Old\Oracle_Analytics.rpd -V 325