Oracle Business Intelligence Enterprise Edition (OBIEE) RPD Management Changes in Version 11g Versus 12c

May 10, 2017

Author: Jordan Adams, Performance Architects

One of the first significant changes you will notice as a developer when upgrading from OBIEE 11g to 12c is RPD management capabilities, including uploading or downloading new or existing RPD models.  In the past, loads were always handled through Enterprise Manager (EM) and required a restart of the server when uploading a new RPD, but with a new tool called data-model-cmd, this is no longer necessary.

With this new functionality, we can run an “Upload a New RPD” or “Download the Existing RPD” command. In order to run these commands, first locate the tool on the server at <Oracle_Home>/user_projects/domains/bi/bitools/bin. The file extension depends on the environment you’re using. For Windows, the extension is “.cmd” and for UNIX it is “.sh.”

Next, write a command to execute one of the two scripts. When uploading an RPD, you need to specify the command “uploadrpd,” which is followed by a set of parameters for RPD location and name (you may also enter the password in this command, and if you do not you will be prompted for the RPD password upon execution); admin username/password; and the OBIEE server instance.  This is an example of the command:

<Oracle_Home>/user_projects/domains/bi/bitools/bin/data-model-cmd.sh uploadrpd -I home/rpd/New_RPD_Upload.rpd -W Admin123 -U weblogic -P Admin123 -SI ssi.  The difference when downloading the RPD is that you’re renaming the RPD to a name of your choice, and the parameter name is slightly altered to as follows: <Oracle_Home>/user_projects/domains/bi/bitools/bin/data-model-cmd.sh downloadrpd -O existing_model.rpd -W Admin123 -U weblogic -P Admin123 -SI ssi.

What are the benefits of these changes?  These changes allow developers an opportunity to make smaller changes and see the impact right away, without having to bring down the environment for all users.  Also, when uploading an RPD, it is much quicker, with one simple command which takes a few moments to complete.  Second, there’s no need to restart services to see changes to the model (unless you’re in “Presentation Services,” in which case you have to log out and back in to see the changes).

Need help with your OBIEE 11g to 12c upgrade?  The Performance Architects team has partnered with several clients on upgrade projects.  Please contact us at sales@performancearchitects.com and we would be happy to explore in more detail with you.


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Leave a Reply