Tag Archives: OBIEE 11g

OBIEE is released – Improved UI and features

Oracle has released new OBIEE and available for download. Some highlights of the new features in this version are:

  • Improved installer
  • NOT supported on 32-bits Operating Systems.
  • Better Administration Features: New monitoring operations via Mbeans,additional information in Usage Tracking tables, new INSTANCECONFIG.xml and NQSCONFIG.INI settings
  • Improved Aggregate Persistence wizard to generate the aggregates with levels auto-correct and etc.
  • Selection Steps & Hierarchical columns can be override with the initialization blocks with its initialization string written in JSON syntax.
  • New light weighted UI Skin: Skyros, Similar to Oracle BI Cloud Service
  • HTML5 output is supported and can be configured as default output format. So flash limits will not stop your analysis on any devices.
  • More settings to configure the exports: columns formatting, Width, No.of rows etc..
  • Ability to save calculated column to reuse in other analysis
  • Better and simple UI (skin & Style) customization with a centralized master CSS and images in one directory.
  • Improved Scheduler WebService methods gives more flexibility to manage the OBIEE Agents programmatically.

And many more can be found in New Features document:


Download at:
New intuitive Documentation Link:
System Certification Matrix:

Shiva Molabanti


Tags: , ,

Upgrade Old nested folders using the Convert Presentation Folders Utility in OBIEE RPD

Starting in Release, you can designate child presentation tables using the Child Presentation Tables tab in the Presentation Table dialog to give the appearance of nested folders in Answers and BI Composer. However, in previous releases, repository developers could achieve one level of nesting in Answers by adding a hyphen at the beginning of a presentation table name, or by adding an arrow (->) at the beginning of a presentation table description.

For e.g.: In previous versions, if you wanted to move the “more Time Objects” to the table/folder, then we will place the ‘->’ in description as shown below.

Convert to Nested folders

If you used these methods to achieve nesting, it is recommended that you run the Convert Presentation Folders utility to convert your metadata to the new structure.


Achieving nesting by adding hyphens at the beginning of presentation table names or adding arrows at the beginning of presentation table descriptions is deprecated for this release and will be removed in a future release.

To use the Convert Presentation Folders utility:

  1. Open your repository in the Administration Tool in offline mode.

Note: Do not run the Convert Presentation Folders utility in online mode.

  1. Select Tools, and then select Utilities.
  2. Select Convert Presentation Folders and click Execute.

The hyphens and arrows disappear from presentation table names and descriptions, and the affected tables are listed as child tables for the appropriate parent object.

Once you converted, the above example will be converted to the new definition as follows:

Convert to Nested folders2

There are no limits on nested folders depth. For more information on nested folders, visit



Posted by on April 24, 2013 in BI Publisher, OBI EE, OBIEE 11g, Weblogic


Tags: , , , , , , , , , , , ,

Things to remember for OBIEE 11G on Microsoft SQL Server

The basic things to remember when configuring OBIEE 11G on Microsoft SQL Server:

1. While running RCU:

  • Use case-sensitive collation in order that the database can reflect any case-sensitivity in your repository naming conventions.
    Run this sql command: ALTER DATABASE OBI COLLATE Latin1_General_CS_AS 
    (This command is for UK English installation, for US locale installation use Latin1_General_CP1_CS_AS)
  • Activate the mechanism of row versioning, so it`s require to enable Read Commit Snapshot.

2. When configuring OBIEE 11G Scheduler with MS SQL server:

When installed with a Microsoft SQL Server 2005/2008 database, the Oracle Business Intelligence installer configures Oracle BI Scheduler with a SQL Server 2005/2008 driver. If multibyte data is used, scheduled jobs might fail. To avoid this issue, use Oracle Enterprise Manager to configure the Oracle Business Intelligence system to use a SQL Server 7.0/2000 driver instead.

To configure Oracle BI Scheduler to use the SQL Server 7.0/2000 driver with Microsoft SQL Server 2005/2008:

  1. After you install Oracle Business Intelligence, log into the system through Oracle Enterprise Manager.
  2. Navigate to the Scheduler tab for the Oracle Business Intelligence server.
  3. Click Lock and Edit Configuration.
  4. Click the Database drop-down list and select SQL Server 7.0/2000.
  5. Click Apply.

3. When configuring OBI Publisher 11G Scheduler with MS SQL server:

Prerequisite: Ensure that the Microsoft SQL Server is set up with mixed mode authentication. Also ensure that the user that you enter to configure the scheduler has the “db_owner” role.

The below table describes the fields for the DataDirect driver to connect to a Microsoft SQL Server 2000 or 2005 database.

DataDirect Driver Fields for SQL Server Databases

Field Entry
Database Type: Select Microsoft SQL Server 2000 or Microsoft SQL Server 2005 from the list.
Connection String: Enter the following connection string parameters: jdbc:hyperion:sqlserver://<hostname>:<port>;DatabaseName=<DATABASENAME> For example: jdbc:hyperion:sqlserver://;DatabaseName=bipscheduler
Database Driver Class: hyperion.jdbc.sqlserver.SQLServerDriver

4. in RPD Development:

  • When you are creating DSN for SQL Server, use sql server native client 10.0 instead of any other drivers. From Sql server 2008 onward, it is strongly recommended even some documents says dont use ODBC native drivers.
  • In RPD, the Query DBMS for SQL server in only work when you specify the DSN name directly (by default it comes with OLAP_DSN session variable).
  • If you have a column with UNIQUEIDENTIFIER as its data type in MS SQL server, then change that column datatype to BINARY(16) or VARCHAR(40) in OBI RPD Physical layer.

5. Performance Tuning:

The following guidelines pertain to performance tuning parameters for Microsoft SQL Server databases. For more information about these parameters, see your Microsoft SQL Server documentation.

  • Store tempdb on a fast I/O device.
  • Increase the recovery interval if perfmon shows an increase in I/O.
  • Use an I/O block size larger than 2 KB.



Posted by on July 2, 2012 in BI Publisher, OBI EE, OBIEE 11g


Tags: , , , , , , , , , , , , , ,

OBIEE Client Tools

Recently Oracle has released a patch for OBIEE to upgrade to with the major bug fixes. But once we upgrade the RPD version raises to and then we cannot open this new version RPD from available OBI Client ( Admin tool.

So we need to download another patch set for Admin tool (in fact, it is a full client tool for

Download patch 13794002 from oracle support.

This patch contains a zip file called Unzip this into a directory.

e.g.: obiee11162patches

Then navigate to /obiee111162patches/13794002/files/clients/biserver

Here you can see two client tool installers for 32-bit and 64-bit Operating systems. Install them based on your system configurations.

biee_client_install.exe (for 32 bit Operating Systems)

biee_client_install_x64.exe (for 32 bit Operating Systems

A sample screens of clients tools




Posted by on June 1, 2012 in BI Publisher, OBI EE, OBIEE 11g


Tags: , , , ,

Oracle Fusion Middleware products on IBM WebSphere Application Server

For those who are interested to know about Fusion Middleware products deployment on application servers other than Oracle weblogic server, here is great information on FMW support with IBM WebSphere Application Server (WAS).

On a high level, An IBM WebSphere Application Server (IBM WebSphere AS) cell contains one Application Server. An IBM WebSphere Application Server Network Deployment (IBM WebSphere ND) cell contains one or more Application Servers that can be clustered for high availability and scaled to meet performance needs.

IBM WebSphere ND Cell Topology:

A typical Oracle Fusion Middleware product environment consists of a cell with Oracle Fusion Middleware Application Servers (including one Administration Server) residing on multiple nodes. The Cluster Member 1 and Cluster Member 2 Application Servers are clustered, with on server one Node 1 and the other server on Node 2, allowing for high availability and scalability. Server 1 and Server 2 are not clustered. To scale the environment, you add additional nodes to the cell by federating a machine to the cell, and then add new servers on those nodes.

Oracle Fusion Middleware configuration steps on IBM WebSphere:

Before you can use Oracle Fusion Middleware products in an IBM WebSphere environment, you must create and configure the cell in which the Oracle Fusion Middleware applications will run. The Oracle Fusion Middleware Configuration Wizard for IBM WebSphere simplifies the process of creating and expanding a cell for your Oracle Fusion Middleware environment. Using the wizard, you can:

· Create new IBM WebSphere cells

· Add Oracle Fusion Middleware products to the cell

· Modify an existing cell

· Add additional nodes to a cell

· Add Application Servers and clusters to a cell

· Configure the resources in a cell

The Configuration Wizard also provides the option to modify the basic configuration that is created by the product template. For example, you can add Application Servers and clusters, change JDBC data source settings, and change deployment targets.

For configuration:

For more information on FMW with IBM WAS, refer

So with this information we can expect that our OBIEE 11G also can be deployed on IBM WebSphere in addition to WebLogic server. But hold on, just wait and see for official document from Oracle. 🙂




Tags: , , , ,

List of Bug fixes in OBIEE

Here is the document provides a listing of Oracle Business Intelligence Enterprise Edition (OBIEE) bugs which have been fixed in the OBIEE release. It also lists the bugs fixed in Oracle Business Intelligence Publisher (BIP) and Essbase

A copy of pdf can be download here: List of bug fixes in OBIEE 11_1_1_6_0





1 Comment

Posted by on March 3, 2012 in BI Publisher, OBI EE, OBIEE 11g


Tags: , , ,

IS OBIEE 11G/FMW supported on VMware?

Virtualization or Raw Metal?

(Orginal link:

With the growing number of customers who want to run the Oracles EPM/BI (or other Fusion Middleware Software) in a virtualized environment, we face a growing number of people asking if running Oracle Software within VMware is supported or not.

Two KM articles reflect Oracles policy towards the use of VMware:
249212.1 and

The bottom line is: you may use it at your own risk, but Oracle does not recommend it.

So far we have seen few problems with the use of VMware (other than performance and the usual limitations) but Oracle does not certify its software for the use in VMware (and specifically for RAC Software actively refuses any support) and any issue that may occur will be fixed for the native OS only.

It is on the customer to prove that the issue is NOT due to VMware in case that an issue is encountered.

See: “Oracle Fusion Middleware Supported System Configurations page

And also

Supported Virtualization and Partitioning Technologies for Oracle Fusion Middleware


Leave a comment

Posted by on November 30, 2011 in BI Publisher, OBIEE 11g


Tags: , , , , ,