Posted  by 

Oracle Obiee 12c Download

OBIEE 12c Installation - Prerequisites

  1. Oracle Bi Publisher Download
  2. Oracle Business Intelligence 12c (12.2.1.0.0) Download
  3. Obiee Download 11g
  4. Obiee 12c Admin Tool
  5. Oracle Obiee 12c Documentation
  6. Oracle Bi Administrator Download

In order to install Oracle Business Intelligence Enterprise Edition (OBIEE) 12c, there are some prerequisites:

- you must have the Java 1.8 installed on that machine;

- you must have Oracle Fusion Middleware installed as well;

- you must have a database to use for OBIEE metadata;

Rutas del sol chuy cantina. The Oracle BI Baseline Validation Tool enables to identify differences during life cycle operations, such as migrating from the Oracle BI 11g release to the 12c release. After we complete the migration procedure, we can use this tool to compare the two deployments and verify whether the data from the 11g environment is correctly copied to the. Documentation for Oracle Business Intelligence Enterprise Edition (Oracle BI EE) on Fusion Middleware 12c (12.2.1.3.0). Links to Additional Book Pages English Arabic Chinese (Simplified) Chinese (Traditional) Czech Dutch French German Hungarian Italian Japanese Korean Portuguese (Brazilian) Spanish.

- you must run the Repository Creation Utility (RCU).

You must have the Java 1.8 installed on that machine.

First of all the the machine you must have Java Development Kit (JDK) 1.8 installed on that machine:

The better is to use the last version of Java 8.

If you are installing the OBIEE 12c on Linux machine you must take a look at the following article :Java 8 installation on Linux .

If you are installing the OBIEE 12c on Windows machine you must take a look at the following article :Java 8 installation on Windows .

You must have Oracle Fusion Middleware (OFM) installed as well.


When you install the Oracle Fusion Middleware, you must install the same version of OFM as the OBIEE version (if not, you have to check the compatibility).

I will install the OFM 12.2.1.2 because I plan to install the OBIEE 12c (12.2.1.2). Here are the steps for installing the Oracle Fusion Middleware 12c Installation for OBIEE 12c (12.2.1.2).

You must have a database to use for OBIEE metadata.

For my installation I will use the Oracle database 12cR1.

You must run the Repository Creation Utility (RCU).

Good news:

In 12c (12.1.2), RCU is available with the Oracle Fusion Middleware Infrastructure distribution.

However, you have to run the RCU beforeinstalling the OBIEE 12c software.

NOTE:

Repository Creation Utility (RCU) will be used for the OBIEE configuration and NOT for OBIEE software installation !


For creating the database schemas needed by the OBIEE 12c, first, you have to run the RCU (Repository Creation Utility):

On Linux operating systems:

cd $ORACLE_HOME/oracle_common/bin

Oracle Obiee 12c Download

./rcu

Where, $ORACLE_HOME = /u01/middleware/12.2.1.

Business

Here are the window that will appear:

Click on 'Next'.

The 'Create Repository' screen will appear into the 'Repository Creation Utility 12.2.1.2.0'.

If you have DBA privileges, choose 'System Load and Product Load'. Click on 'Next'.

The 'Database Connection Details' screen will appear into the 'Repository Creation Utility 12.2.1.2.0'.


Input the Database Connection Details. Click on 'Next'.

The following screen will appear into the 'Repository Creation Utility 12.2.1.2.0'.

Click on 'OK'.

The 'Select Components' screen will appear into the Repository Creation Utility.

Check the 'Oracle Business Intelligence'. Other components will be checked automatically. Click on 'Next'.

The following screen will appear into the Repository Creation Utility.

Click on 'OK'.

The 'Schema Passwords' screen will appear into the Repository Creation Utility.


I will input a password for all schemas. Click on 'Next'.

The 'Map Tablespaces' screen will appear into the Repository Creation Utility.

Click on 'Next'.

The following screen will appear into the Repository Creation Utility.

Click on 'OK'.

The following screen will appear:

Click on 'OK'.

The 'Summary' screen will appear into the Repository Creation Utility.


Click on 'Create'.

The following screen will appear into the Repository Creation Utility:

When all is done, you will see:

At this point the RCU has finished its job.

When all these steps are done, you can start the OBIEE 12c installation (my example is on Linux 6).

Please click the Like Button if you find this blog helpful. Thank you.

IUnder the covers of OBIEE 12c there are still a lot of similarities to OBIEE 11g and one of those is the RPD (Repository Metadata) file. This contains the data models, data source details, custom calculations, dimensional details and so on that bring the power to OBIEE’s reporting capability.

Editing the RPD is still performed using the Administrator tool – a windows only utility that is installed with the OBIEE Client tools.

The Administrator tool lets you edit the data model in on-line or off-line mode. In on-line mode obviously all changes are immediately saved to the live RPD file and are available to users after a metadata refresh within OBIEE. This is pretty much the same as in 11g.

In off-line mode you can edit an RPD file downloaded from the OBIEE server and the changes are not available in OBIEE until you re-upload the RPD file. It is in downloading & uploading the RPD file where OBIEE 12c is very different from 11g.

In 11g you could simply FTP the current RPD file down from the server, edit it in the Administrator utility and then use the Enterprise Manager Deployment screen to upload it, followed by a manual restart of the OBIEE components. Or if you preferred, stopped OBIEE, FTP’d the file back to the server and restarted OBIEE.

In 12c you cannot simply FTP the current RPD down from the server and the enterprise manager no longer contains a deployment screen to put it back!

So firstly, where is the RPD file?

Many directories in the OBIEE installation have changed in 12c and the RPD now is located in:

Note the <SSI> – this is the instance name of your OBIEE install. Unless you’ve changed it, it’ll probably be ‘ssi’. Look in the <obiee_home>/user_projects/domains/bi/bidata/service_instances directory to find it.

However if you look in this directory it’s a little odd:

The liverpd.rpd is the file that was installed when OBIEE was installed and the liverpd.rpd_1 and liverpd.rpd_2 files are copied created following successive on-line edit sessions. So liverpd.rpd_2 is the current ‘live’ RPD file. OBIEE automatically copies and numbers the RPD files as you make on-line changes.

However you can’t simply copy the latest RPD file and open it in Administrator:

It asks for a password. Any ideas what that might be? No password has been mentioned anywhere during the installation, so this must be an internal password designed to stop anyone just copying the RPD file and editing it.

To download an RPD file for editing you need to use a new utility called data-model-cmd.sh (probably data-model-cmd.cmd on windows) which is located in the <obiee_home>/user_projects/domains/bi/bitools/bin directory.

So in my case I ran the following command to copy the RPD file to a new file called obiee.rpd:

The below command is able to run on the server where OBIEE 12c is installed. Also make sure that the OBIEE server is up and running during this download. There are other parameters such as server name, port number etc, which you don’t need if running the command on the OBIEE server where the RPD file is located.

C:OBIEE12cMiddlewareOracle_Homeuser_projectsdomainsbibitoolsbindata-model-cmd.cmd downloadrpd -O obiee.rpd -SI ssi -U weblogic -P oracle123

In above command:

  • downloadrpd – the instruction to download the RPD (as opposed to upload, see later)
  • -SI the OBIEE service instance, e.g. ssi
  • -O obiee.rpd – is the name of RPD will be saved in the current directory.
  • -U weblogic – is the username.
  • -P oracle123 – this is the password for user weblogic used to login on OBIEE website/Dashboard.
  • RPD Password – Finally it ask for the RPD password. the default password of SampleApp RPD is “Admin123”.

Upon running it prompts you to enter a password for this RPD file. It doesn’t ask you to confirm this, so make sure you know what you entered or else you’ll need to re- run the command to download it again!

Once downloaded (although it is still on the server, in my case in the /u01/temp directory) you can FTP it to your local pc and open it in the Administrator tool. You are prompted for the password you entered above and then the RPD should open. For opening the Admin Tool to open RPD, it resides at the below mentioned screenshot:

Open the RPD now in this.

You are now free to edit the RPD as you need.

Uploading RPD files into OBIEE

To upload the RPD back into OBIEE you need to reverse the process for downloading above. So start by FTPing the file back up to the server. So here my temp directory now has the original downloaded RPD and my new edited version:

Oracle Bi Publisher Download

To upload the RPD we use the same data-model-cmd.sh command but with slightly different parameters:

Oracle Business Intelligence 12c (12.2.1.0.0) Download

  • uploadrpd the instruction to upload the RPD.
  • -I rpdfilename the name you want to give to the RPD file you’re uploading
  • -SI the OBIEE service instance, e.g. ssi
  • -U the weblogic administrator user-id
  • -P the weblogic administrator password

So I ran the following command:

C:OBIEE12cMiddlewareOracle_Homeuser_projectsdomainsbibitoolsbindata-model-cmd.cmd uploadrpd -I obiee.rpd -SI ssi -U weblogic -P oracle123

ou are prompted to enter the RPD password, the same one you entered when downloaded it.

Now a quick look in the RPD directory shows it’s done a bit of tidying up:

The original RPD from the installation have been cleaned out only my new RPD along with older version with _1 is there. _2 is the latest RPD uploaded by me.

Obiee Download 11g

Now before any of you wise guys try the obvious, I’ll stop you now…you can’t now FTP the current live RPD file from this directory and open it in the Administrator tool thinking that you now know the password…obviously you know it, you entered it when uploading it, right?…wrong, it changes the password during the upload. Oracle know us too well

What is good about the uploading of the RPD with the data-model-cmd.sh is that it is quick – I assume it doesn’t perform a restart of the OBIEE components, its way faster than the old enterprise manager restart, so presumably it’s performing a server metadata refresh instead.

Obiee 12c Admin Tool

Oracle Obiee 12c Download

So there you have it, a quick overview of how to download/upload the RPD file in OBIEE 12c. It might seem a little complex to start with, but once you know the data-model-cmd.sh command (and scripted it for your environment, which I will certainly do!), it’s a big improvement over the 11g method of deployment RPD files.

Oracle Obiee 12c Documentation

Enjoy!

Oracle bi download

Oracle Bi Administrator Download

Please click the Like Button if you find this blog helpful. Thank you.