OBIEE 12c “A new era of Oracle Analytics” – The New features

OBIEE 12c has been launched with couple of Brand new exciting features and with couple of major enhancements from its predecessor. The enhancement has been made in Visualizations, Platform Architecture, Installation and Configuration, Migration and deployment. Also major enhancement made on the directory structures and no more complicated lengthy path of Weblogic directories and its more clean and pristine.

Lets isolate each areas and see what are the major enhancements:

  1. Installation And Configurations
  2. Multi-tenancy (MSI) and Pluggable BI
  3. BI Application Archive(BAR)
  4. OBIEE Server level enhancements – In-memory analytics and Advanced analytics
  5. Data Mashups for Answers
  6. Visual Analyzer
  7. Better Mobile Analytics

I am going to touch the UI enhancement first on Visual Analyzer (as I know this is going to be very attractive features and major highlight of this release).


  • VA is a very strong web based tool has new generation Answers capability for self-service analysis.
  • VA is quick data exploration and data discovery tool which can build rich dashboards on-the-fly in very quick turnaround time. Rich analysis possible with drag and drop configuration
  • It has very easy and swift transitioning palette and quick slice and dice features.
  • Very simple user friendly input which can create very rich graphics with different options of exploring the data, discovering the patterns and seeing trends.
  • Provide highly interactive experience with intuitive filtering and cross visualization brushing and highlighting
  • Visual Analyzer is not intended to be a standalone reporting tool. Visual Analyzer makes use of the existing Oracle BI EE
    repository, which means that all your Oracle BI EE 11g data sources can be leveraged to allow users to explore existing data warehouse content.
  • Visual Analyzer uses Presentation Services data models as a content source, relies on the catalog to store content, uses the search infrastructure to find content and relies on a common security model for managing roles and permissions.
  • VA use rich modern java-script library and rendered through HTML5
  • Using VA you can create advanced graph, blend of color , size , shape , palette using various co-ordinate systems

VA01 VA02 VA03

You can modify and manipulate data model on-the-fly

VA04 VA05VA Integrates any kind of data source, it is powerful tool to load and model data. You can smartly blend the personal and external data.

It has a nice global searching capabilities on any measure/object name like Qlikview.



You can upload your own datafile like xls data , match with existing OBIEE model and generate on the fly customized reporting. Internally its logical SQL extension to directly call external data. Just in time modelling with measures and attributes, mashup across enterprise and user defined data.

Data mashup also include OBIEE embedded data store for user uploaded files.

A simple MASHUP Architecture like below :


VA07 VA08 VA09 VA10 VA11Quick reporting by picking up right metrics and showing data and Easy content search

VA12VA13 VA14 VA15 VA16 VA17

C) Advanced Analytics Capability

Predictive analysis is more tightly integrated, enabling customers to more easily forecast future conditions based on existing data points, group elements that are statistically similar, and expose outliers.  BI 12c includes the ability to run the free Oracle R distribution on BI Server, and extend existing analytics with custom R scripts, which can point to any engine (R, Oracle Database, Spark, etc.) without needing to change the BI RPD to deliver results.


D) In-Memory Analysis

Misc02 Misc03

E) 11g to 12c UPGRADE – Pluggable Model and BAR/BVL

Oracle BI Baseline Validation Tool – Complete New Capability
• A tool that enables the creation of a baseline set of data that is then able to be compared with data from another (or the same) system that may be the result of an upgrade, patch or migration, or any change
• A way to perform regression testing on any two compatible Oracle BIEE environments
–Works within and across 11g and 12c versions
• A way to instill confidence when performing an upgrade, migration or significant change to an existing environment

Misc04The baseline validation tool interfacing both 11g(Pre-Upgrade) and 12c (Post-Upgrade) which will give the capability of easy testing plus validating data set, Logical query pre and post upgrade. It is going to a a very essential feature and reduce lot of testing time and effort for sure. Oracle called this as Pluggable model.

The following modules will be available here:
– Data verification
• Compare result output (i.e. actual numbers or text) from different versions
– Visual verification
• Capture screenshots of reports to check they are visually the same
– BI catalog verification
• Capture object and metadata and compare with the target system
– Logical query verification
• Capture logical query definitions and compare with the target system
– Performance verification
• Capture performance profile to check there’s not degradation


F) Multi-Tenancy Model / Multi-Service Instance (MSI) enabled

Multitenancy refers to a principle in software architecture where a single installation of the software runs on one server or clustered servers, serving multiple client organizations.With a multitenant architecture, each client organization operates
independently of other organizations that share the same infrastructure. Multitenancy offers the ability to host multiple companies (even competitors) in one deployment without them knowing of each other.

Misc05 Misc06

G) System Administration and Configuration

  • Single Source for BIPLATFORM schemas. No Information on DB and topology info stored in Database
  • Full offline configuration speed up domain creation
  • Separate OBIEE Installation and Config (it was just reverse than 11g when RCU creation was first step)
  • Chef Capability allow most of the config parameters to be edited
  • One place to edit environment and/or configuration so no more duplication in config files
  • BI 12c will use CAM (not OPMN) to manage system components.All CAM-related configuration is also stored in DOMAIN_HOME.
  • Singleton Data Directory (SDD)– Simple conversion to HA scale-out
  • Zero downtime: All system and application operations should be supported on-line. No requirement for downtime of end-user functionality
  • Support offline configuration: All system and application configuration operations should be off-line. No requirement for run-time mid-tier processes to be started.
  • No more Middleware Home and all under one Oracle_Home.
  • No more OPMN . Everything managed inside weblogic
  • Migration process has been simplified in great extent using BAR files and easy validation tool pre and post migration
  • The Oracle BI Server supports the Fast Application Notification (FAN) event and Fast Connection Failover (FCF) Oracle Database configuration. It is excllent feature to add offline failover of the database connections. Fast Connection Failover enables quick failover when the data source’s Oracle database is not available. According to the documentation, This functionality will run in the background. When an Oracle Business Intelligence query initiated by an analysis user fails due to the Oracle database being unavailable, the query will fail quickly and the user can then retry the query rather than waiting for the database request to time out.
  • Invoke of the WLST from a single location

H) Mobile Analytics

  • Sharp Mobile UI interfacing with rich colors
  • Mobile Indexing data
  • Fast Mobile data query
  • Keyword search (“BI Ask”) empowers users to literally talk to their data, asking questions and having visualizations automatically created as responses, opening up an easy entry point for authoring.  Additionally, the interface for iOS has been completely redesigned; and Mobile BI for Android offers sharing and following for nearby devices, as well as the ability to project any dashboard or story to GoogleCast-enabled devices.

I) Repository enhancements

This is In progress. I will update pretty soon…

— Thanks

OBIEE 12c(OBIEE Installation guide on Linux Platform

Oracle Business Intelligence Enterprise Edition 12c – OBIEE released on OTN 26th Oct 2015. As soon as I get all the downloadable contents this is my first attempt to install the software.

We know Oracle has made bunch of amendments / enhancements to 12c on top of very successful 11g release. I am going to blog couple of new 12c features pretty soon in terms of UI as well as config changes.

So lets first follow the step by step process to install the software(64 bit) in my Oracle Linux 6.0 OS .

Step 1 – Download and Procure the required files

Download Oracle Business Intelligence 12c from :

1Unlike 11g the installation files are little different and need to installed as per mentioned order. As I am using the server version I have downloaded below files :

2So you have to download and Install JDK first. For me, I have downloaded jdk-8u66-linux-x64.rpm package.


So it looks like First JDK , then Weblogic and then OBIEE main installer and no separate RCU required to be installed. Also notice the files are little bit different with .jar for Weblogic Infrastructure and .bin for OBIEE installation.

Step 2 – Install JDK

Should be simple install command:

sudo yum localinstall jdk-8u66-linux-x64.rpm

Post install verify the version:


Step 3 – Install below Prerequisite packages


Should be simple sudo yum install command

Step 4 – Install Weblogic (Fusion Middleware) Infrastructure

My Linux server has 48 GB Memory with 140GB storage available to perform the installation. It is the simple java command to Launch the setup.

5So this opens the Oracle Inventory window: Select default Inventory location :

Middleware-Install-01Middleware-Install-02Middleware-Install-03 Middleware-Install-04 Middleware-Install-05 Middleware-Install-06 Middleware-Install-07 Middleware-Install-08 Middleware-Install-09 Middleware-Install-10Middleware-Install-11

Step 5 – Install OBIEE 12c Software

Execute the binary content as below:


Step 6 – Configure RCU, Middleware, OBIEE

In this step we have to run some config setup file to configure RCU , Middleware domain .

I would prefer to install RCU separately (using ……\Middleware\Oracle_Home\oracle_common\bin\rcu.bat)before you come to this step because RCU creation , DB type validations etc can results several errors which you want to be fixed before Middleware config started.

Config01 Config02 Config03

In Below steps if you see error called Domain “bi” already exists then remove the content from below and click Next.


You can experience this issue only if you aborted any previous session of the config steps.

Config04STOP here and check if you have 12c Database or at-least 11g R2 ( installed where you are trying to create RCU. If not then it will throw you error and Installer will abort.

RCU2Also check the Database Character Set otherwise you will get warning to change data-set to AL32UTF8 like below:

issue 1For me it was WE8MSWIN1252 in Oracle Db 12c and I have executed below steps to changed it to acceptable CharacterSet.



— if the above fails:

Also If your 12c Database configured with multi tenancy Container Database RCU can’t be created and it will give below error:

issue3I have resolved that error using below steps: fortunately for me during Oracle Db 12c installation I have clicked option ‘pdborcl’ as Pluggable database.

  1. Connect as sys user as sysdba
  2. then execute  : ALTER SESSION SET container = pdborcl ;
  3. select name, open_mode from v$pdbs;   — it should return pdborcl
  4. Alter pluggable database all open;
  5. Add below in TNSNAMES.ora

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(SERVICE_NAME = pdborcl)

If everything works great follow next steps of Configuration:


Config06 Config07 Config08 Config09 Config10As mentioned before If you encounter issue with RCU installation just isolate this configuration step from it and trigger RCU script from :


This will prompt a RCU Config steps and you can debug any issue here like SYSDBA privilege, Connect String issue, Port issue, password issue etc etc. Here is sample screen.


Assuming the installation and configuration steps completed. Notice there are change of ports in 12c comparing 11g:

WebLogic Console
Fusion Middleware Control
Visal Analyzer
BI Publisher
BI Analytics

Step 7 – Testing post Installation / UI

This is Analytics:

analytics01analytics03This is visual Analyzer:analytics02 Some of the Visual Analyzer interfaces:

analytics04 analytics05 analytics06