Deploying/upload rpd in OBIEE / 12c server


Dear All,


We will learn how to upload / deploy new rpd in obiee 12c server.

Unlike in 11g, em does not have any option for deployments of rpd, it is all now uploading repository to a specific service instance. we should be using weblogic scripting command “uploadrpd’ to upload repository to Oracle BI Server.

You execute the utility through a launcher script, on UNIX and data-model-cmd.cmd on Windows. You can find the launcher script at the following location:




uploadrpd -I <RPDname> [-W <RPDpwd>] -SI <service_instance> -U <cred_username> [-P <cred_password>] [-S <hostname>] [-N <port_number>] [-SSL] [-H]


  • I specifies the name of the repository that you want to upload.
  • W is the repository’s password. If you do not supply the password, then you will be prompted for the password when the command is run. For security purposes, Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.
  • SI specifies the name of the service instance.
  • U specifies a valid user’s name to be used for Oracle BI EE authentication.
  • P specifies the password corresponding to the user’s name that you specified for U. If you do not supply the password, then you will be prompted for the password when the command is run. For security purposes, Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.
  • S specifies the Oracle BI EE host name. Only include this option when you are running the command from a client installation.
  • N specifies the Oracle BI EE port number. Only include this option when you are running the command from a client installation.
  • SSL specifies to use SSL to connect to the WebLogic Server to run the command. Only include this option when you are running the command from a client installation.
  • H displays the usage information and exits the command.

Example: uploadrpd -I <RepositoryName.rpd> -SI ssi -U weblogic -S -N 9502 -SSL


Note: Using “uploadrpd”, we can upload an Oracle BI repository in RPD format and cannot upload a repository composed of MDS XML documents.

The online rpd in the server is with name liverpd.rpd_n (n is integer with increased number) and can be found at: <Oracle_Home>\user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations

You can log into analytics and see the subject area contents of new rpd with changes affected.

You can also download current online rpd from server which acts as offline rpd on which you will be developing your changes or for any diagnose purpose

syntax: downloadrpd -O RPDname [-W RPDpwd] -SI service_instance -U cred_username [-P cred_password] [-S hostname] [-N port_number] [-SSL] [-H]


rpd will be saved under the same location where you executed above command..





OBIEE New & Deprecated Terminology and architecture – (12c)


Dear all,

from oracle documentation, here is high level architecture diagram for OBIEE 12c – and terminology difference between 11g & 12c


Terminology difference.

Terminology Used in 11g Terminology Used in 12c
Middleware home


In 11g the Middleware home is a container for the Oracle WebLogic Server home, and, optionally, one Oracle Common home and one or more Oracle homes.

This term is eliminated in 12c.

Oracle home


The Oracle home that is created for all the Oracle Fusion Middleware products on a host computer. It includes binary and library files, the Oracle common directory and the individual product directories for each Oracle Fusion Middleware product you install.

Oracle home


Product directory


The product directories within the Middleware home are no longer Oracle homes. They are simply directories within the Oracle home that are created for all the Oracle Fusion Middleware products. Most Oracle Fusion Middleware components should be installed in the same Oracle home. The names of the product homes are predefined and can no longer be modified by the user during the installation.

Oracle instance

This term is eliminated in 12c.

The installer will no longer create a separate instance directory for system components, such as Oracle HTTP Server. Instead, you can use the Fusion Middleware Configuration Wizard to configure your system components, just as you do for Java components. Instance information about each system component will be stored in the domain home.
Oracle Fusion Middleware farm

This term is eliminated in 12c.

The term “farm” is no longer necessary for 12c. It was used in 11g to refer to a container for a WLS domain and its associated system component instances when presented in Fusion Middleware Control.





OBIEE 12c Installation on windows 8




obiee 12c ( installation is success in my windows 8 version (note it is not oracle recommended but for practice purpose i tried and able to install)

Generalizing the process of installation …


  1. 64 bit OS is must
  2. Loopback adapter settings..
  3. Make sure you unzip the downloaded setup files in the same machine where you’re intended to install obiee. I saw few issues when extracted file is brought from 2008 r2 to win8.
  4. Decide user with whom you’re proceeding with installations and ensure oraInventory access.
  5. Windows firewall set to Off
  6. JDK 1.8.0_51+
  7. oracle database;;

For more information on certification matrix on oracle fusion middleware certification, click here

Installation Steps:

  • Install Oracle Fusion Middleware Infrastructure (no configuring domain for infrastructure)
  • Install obiee
  • Set BI_PRODUCT_HOME env variable for ex: C:\oracle\product\Middleware\Oracle_Home\bi
  • Configure obiee standard topology using 12c configuration assistant(you can alternatively run rcu part of <ORACLE_HOME>/oracle_common/bin to create schema required then sue configuration assistant to configure obiee)

Follow oracle documentation on installation & configuration here

i could not install obiee 12c ( on windows 2008 r2 and the same success with windows 8

Note: Oracle certifies only 2012 r2 for obiee 12c




BI Publisher Desktop Not Showing Add-in / BI Publisher Installation Issue “Please make sure JRE version 1.6 or later is installed”


Hello There,

Recently i was facing issue with BI Publisher Desktop tool. I am not able to see the add-in in MS word.

Also sometimes i could not proceed with the installation says: “Please make sure JRE version 1.6 or later is installed” though i had 1.6 later or later versions.

It happened when machine is: Windows 7 – 64 bit; but MS Office & client tool ( of 32 bit.

Follow Oracle Doc: 1464328.1 has fix for it.

Complete the following steps:

  1. Download the offline installer for Java from this page:

    Make sure to download both Windows Offline (32-bit) and Windows Offline (64-bit).

  2. In Windows, go to the Control Panel –> Programs and Features.
  3. From the list of installed programs, uninstall all Java / JDK programs from your PC (both 32-bit and 64-bit)
  4. Reboot the PC
  5. Install the Java Windows Offline (32-bit)
  6. Install the Java Windows Offline (64-bit)
  7. Reboot the PC
  8. Install Oracle BI Publisher Desktop


Kishore Guggilla

Level Based Measures in OBIEE & Tableau


Level based Measures in OBIEE

A level-based measure is a column whose values are always calculated to a specific level of aggregation. Let us take an example of Products and Revenue table. A level based hierarchy is created for Products as follows:


By default, in the report when we drill down the products hierarchy from Brand level to Product level, the corresponding Revenue drills down to Product level.

However, if we want to view the revenue aggregated to the Brand level then:
● We create another measure called “Brand revenue” which is a duplicate of revenue in RPD.
● Click on its properties, in the level tab specify the logical level as “Product Brand” for Logical Dimension “H2 Product”. Save the RPD.


● When Brand revenue is dragged into our analysis, it shows Revenue for Brand level, no matter how far we drill down from the brand level.


Level Based Measures in Tableau

To get the similar kind of functionality in Tableau,
● we create the hierarchy for products.
● Drag Product hierarchy and Revenue into the view.


● Right click Revenue, click ‘Add table Calculation’.
● Click on ‘Customize’ button in the Table calculation window and write the formula “WINDOW_SUM(sum([Revenue]) )” in ‘Calculated Field’ window . Press Ok
● Select ‘advanced’ option in dropdown menu for ‘compute using’ field in Table calculation window.


● Push ‘Type’ and ‘Product’ to ‘Addressing’ column. Click OK & OK again to return to the view.


● We can now see that the Revenue is aggregated to the Brand level, even when Product Brand is drilled down to Product level.


Difference between OBIEE Level Based Measures and Tableau Table Calculations:

OBIEE will send a query to the database to calculate level based measures. Table calculations, on the other hand, are not executed by the database but rather calculated by Tableau on the
query results that get returned. If table calculation performance is a problem (possibly
because the result set being returned to Tableau is very large) consider pushing some aspects of the calculation back to the data source layer. One way to do this is to leverage an aggregated data extract.

Naresh Meda

Complex Joins in OBIEE 11g


Hi All,


Like 10g, we do not have available option to create Complex Joins from Toolbar. Can only create “Foreign Key” Joins.

But we can create complex joins using Join Manager. (This option not available from tool bar)


Go to Manage > Joins > Actions > New > Complex Join.

Browser the physical tables on which you want to perform joins then create complex join. 

As you might know complex joins will be used when we have to mention case when condition, or condition..etc in our jion 





OBIEE 11g Issues with Chrome 30


Hi All,

After long time, got some time to blogging.

Recently i experienced a issue with chrome after it got auto-upgraded to 30.

OBIEE 11g is behaving weirdly and showing some pop-ups listed below. And, not able to open report in edit mode…etc.

Cannot call method ‘replace’ of null”

Cannot read property ‘TimeZoneId’ of null“,

cannot read property ‘itemsinfos’ of null.”,

Page XX.XXX.XXX.XX:9704 description: 
ReportPageEditor.prototype.load expecting 
<saw:report>, receive <null>”

Apart from these, other issues:

you can no longer open the list of web catalog, nor are you able to select the list of  subject areas.

Dashboard prompts list is not available..etc


Cause: Content-Type’ post header is not set correctly for Chrome v30.



This is fixed in OBIEE and later versions.

Download and apply patch 16068402 for OBIEE

For OBIEE, as these version no longer have error correction support, either upgrade to OBIEE or,

For all versions of OBIEE, the work-around is to use Chrome with a version lower than 30 or another browser, such as Internet Explorer or FireFox


Ref: 1590991.1 from MOS



Kishore Guggilla