Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

Home/Installation, OBIEE/Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytic Installation

 

032317_0218_StepbyStepI1 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

In this section, I have explained  OBIEE 12C installation on a Windows Machine. The following bi components will get covered in this section

  • Oracle BI Publisher installation
  • Oracle BI Analytics installation
  • Essbase

Pre-Requisite

Following are the series of steps covered in this section

  • Download & Unzip OBIEE 12.2.1
  • OBIEE 12.2.1 Installation
  • Create BI Schemas using RCU utility
  • Set Environment Variable for BI
  • Create a BI Domain
  • Verify Oracle Business Intelligence URL’s
  • Start & Stop BI Server

1). Download & Unzip OBIEE 12.2.1

1.1) Go to Oracle BI download URL, Accept the license, and download the Windows downloads File1 & File2

032317_0218_StepbyStepI2 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

1.2) Unzip the two zip two files in a folder as shown below

 

032317_0218_StepbyStepI3 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2). OBIEE 12.2.1 Installation

 

2.1) Right click on the BI Installer and select Run as Administrator

 

032317_0218_StepbyStepI4 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.1) The BI Installer opens on the screen

 

032317_0218_StepbyStepI5 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.3) Click the button Next on the installer

 

032317_0218_StepbyStepI6 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.4) Input the Oracle support credentials if you have for automatic updates or skip it

 

032317_0218_StepbyStepI7 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.5) Input the Middleware home. This is the folder where you installed Fusion Middleware 12.2.1. Look at Fusion Middleware installation on step 7

 

032317_0218_StepbyStepI8 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.6) Toggle on BI Platform Distribution with Samples

 

Note: If you are installing it on a DEV box, I would suggest to install it. It has plenty of samples to refer

 

032317_0218_StepbyStepI9 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.7) Click the button Next

 

032317_0218_StepbyStepI10 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.8) Click on the button Install

 

032317_0218_StepbyStepI11 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.9) Click Next once it went 100%

 

032317_0218_StepbyStepI12 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

2.10) Click Close to complete the setup

 

032317_0218_StepbyStepI13 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3). Create BI Schemas using RCU utility

 

3.1) Go to <MW_HOME>\oracle_common\bin and double click on the rcu.bat

 

032317_0218_StepbyStepI14 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.2) Click on the button Next

 

032317_0218_StepbyStepI15 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.3) Click Create Repository and click Next

 

032317_0218_StepbyStepI16 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.4) Select your database and input the SYSDBA credentials

 

032317_0218_StepbyStepI17 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.5) Click Ok on the pop-up

 

032317_0218_StepbyStepI18 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.6) Input a prefix and enable Oracle Business Intelligence

Note: The prefix in Create New Prefix is important. You need this prefix while creating a BI domain

 

032317_0218_StepbyStepI19 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.7) Click Ok on the pop-up

 

032317_0218_StepbyStepI20 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.8) Input a password for the BI schema Password

Note: Save this password. You need this while creating BI domain

 

032317_0218_StepbyStepI21 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.9) Accept the default or double click on the tablespace to select your database. Click Next

 

032317_0218_StepbyStepI22 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.10) Click Ok on Repository Creation Utility – Confirmation pop-up

 

032317_0218_StepbyStepI23 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.11) Click Create on Repository Creation Utility

 

032317_0218_StepbyStepI24 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.12) Click Ok

 

032317_0218_StepbyStepI25 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

3.13) Click Close once it was done

 

032317_0218_StepbyStepI26 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

4). Set Environment Variable for BI

 

4.1) Open your control panel >> System >> Advanced System Settings >> Advanced >> Environment Variables >> Add the variable BI_PRODUCT_HOME points to your <MW_HOME>\bi folder

 

032317_0218_StepbyStepI27 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5). Create a BI Domain

 

5.1) Go to <MW_HOME>bi\bin folder and run config.cmd

 

032317_0218_StepbyStepI28 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.2) The Oracle Business Intelligence 12C Configuration Assistant opens on the screen. Select the option you want

  • Essbase => OLAP server
  • Business Intelligence Enterprise Edition => BI Analytics
  • Business Intelligence Publisher => BI Publisher

 

032317_0218_StepbyStepI29 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.3) Click Next

 

032317_0218_StepbyStepI30 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.4) Input a BI domain name & WebLogic username and password

 

032317_0218_StepbyStepI31 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.3) Select Use existing schema and input your database connection string

Simple Connect String: localhost:1521:orcl                (Sample Format)

Prefix: Mentioned in step 3.6

Password: Mentioned in step 3.8

 

032317_0218_StepbyStepI32 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.4) Input a port range, so BI will choose port number for WebLogic admin server and BI servers

Port Range Starting Port: Port From

Port Range End Port: Port To

 

032317_0218_StepbyStepI33 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.5) Select the Oracle Sample application (SampleAppLite) & click Next

Note: By selecting the SampleAppLite, BI Analytic display predefined dashboard. Useful in DEV server for reference

 

032317_0218_StepbyStepI34 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.6) Click Configure

 

032317_0218_StepbyStepI35 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.7) The Bi domain configuration will get started. It would take 15-30 minutes depend on your process speed

 

032317_0218_StepbyStepI36 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.8) You may receive multiple pop-ups during this process. Click Allow access

 

032317_0218_StepbyStepI37 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.9) Click Next once it went 100%

 

032317_0218_StepbyStepI38 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

5.10) Scroll down and look at the port numbers before closing the wizard. Click Finish to exit the setup 

 

032317_0218_StepbyStepI39 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6) Verify Business Intelligence URL’s

 

6.1) Verify the BI Analytic URL. The URL will be like HTTP://<HOSTNAME>:<PORT>/analytics. Enter your WebLogic credentials and login

Note: The port number is mentioned in step 5.10

 

032317_0218_StepbyStepI40 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.2) To see the sampleAppLite dashboard, Select the Dashboard dropdown and select anything under Sample Lite

 

032317_0218_StepbyStepI41 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.3) The BI analytics SampleAppLite dashboard

 

032317_0218_StepbyStepI42 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.4) Open BI Publisher URL with WebLogic credentials. The default URL will look like http://<HOSTNAME>:<PORT>/xmlpserver

 

032317_0218_StepbyStepI43 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.5) Open a sample report

 

032317_0218_StepbyStepI44 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.6) The sample BI Publisher report

 

032317_0218_StepbyStepI45 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.7) Go to Visual Analyzer URL and login with your WebLogic username and password

 

032317_0218_StepbyStepI46 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

6.8) BI Visual Analyzer dashboard. The default URL will be http://localhost:9502/console

 

032317_0218_StepbyStepI47 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.9) Verify the status of the Oracle Essbase application. The URL will be like http://localhost:9502/aps/Essbase

 

032317_0218_StepbyStepI48 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.10) Login into WebLogic console with your WebLogic username and password. The default URL is http://localhost:9500

 

032317_0218_StepbyStepI49 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

6.11) Login into WebLogic Enterprise manager with your WebLogic username and password. The default URL is http://localhost:9500/em

 

032317_0218_StepbyStepI50 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

7) Start & Stop BI Server

 

7.1) Go to <MW_HOME>\user_projects\<DOMAIN_NAME>\bi\bitools\bin and run the command as shown below

Start.cmd => Start BI Server

Stop.cmd => Stop BI Server

Status.cmd => Status

 

032317_0218_StepbyStepI51 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

For Example, Double click on status.cmd will give BI status like below 

 

032317_0218_StepbyStepI52 Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation

 

What Next? 

Click on those following links to begin with BI Publisher . 🙂 

How to set up a data source in BI Publisher

How to create report in bi publisher

govindan Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan Step by Step OBIEE 12C Installation on Windows – BI Publisher installation, BI Analytics Installation
Connect me
Like us on Facebook.
Connect!