OBIEE Metadata Upgade (10g To 11g) - RPD

OBIEE Metadata Upgrade (10g to 11g) - RPD 

Like most software upgrades, generally the newer version would provide some type of backward compatibility. Well, with the recently released Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, you will not have the ability to do so. Due to the major enhancements of the OBIEE toolset, there is no way to seamlessly migrate our metadata from 10g to 11g. The road ahead may be a little gloomy for 10g but fear not, there is still some light down the tunnel. Fortunately, bundled with OBIEE 11g is an upgrade utility called “Oracle Fusion Middleware Upgrade Assistant.”  

The Upgrade Assistant provides option for RPD and Presentation Catalog upgrades. In Part 1, we will tackle the RPD metadata upgrade. To see how to upgrade your Presentation Catalog metadata, please jump to Part 2 of our OBIEE Metadata Upgrade.

Now to the juicy part — The Upgrade Assistant utility only has 8 steps and is extremely user-friendly: 

1.  Upload your 10g RPD onto the Box where you have previously installed OBIEE 11g

2.  Now navigate to $OracleBI_HOME/bin and execute the “ua” utility

3.  This utility is available in both Windows and Linux



– Check “Upgrade Oracle BI RPD and Presentation Catalog” and click “Next”

4.    Since we are only upgrading our RPD, check “Upgrade Repository (RPD)” on the next screen  

5.   Provide the Username/Password for Administrator (i.e. Administrator/Administrator

6.   Starting OBIEE 11g, there is a new security feature: The RPD now has a password as well!!!! This security is partially to protect the RPD access, but largely to prevent overwriting the RPD on the server itself. Users without RPD password will not be able to push a new or updated copy of RPD to the BI Server. With that in mind, provide RPD password (i.e. SADMIN) and click “Next” 

 7.   In this version, weblogic is bundled with OBIEE, so generally it is installed on the same box, if not, specify the required connection details: 

8.   Review your upgrade configuration and complete your upgrade process 

There are some issues with joins in the RPD’s physical and logical diagram.
In order for you to fully complete this upgrade, all your joins may have to be recreated manually.