New Features in OBIEE11g compared to OBIEE10g

There has been a lots of new feature introduced in OBIEE11g version with comparing to the earlier 10g version. Let’s go through some of the most important enhancements in OBIEE1g.

Administration tool:

The most significant difference between OBIEE 10g and 11g -

Deployment to Oracle WebLogic Server (WLS) and the integration of OBI with Oracle Fusion Middleware Control

The administration is done using:- 
 Oracle WebLogic Server Administration Console and Fusion Middleware Control  

The configuration settings are now managed by Fusion Middleware Control.

Security:

In previous version of Oracle Business Intelligence the users and groups could be defined within a repository file whereas in current 11g version users and groups are defined using an Oracle WebLogic Server authentication.

It is now possible for OBIEE to find out the "groups" belonging to a user directly from LDAP with the new 11g security model.

Oracle OLAP Integration:

OBIEE 11g supports Oracle OLAP as a data source. If you need to optimise the underlying Data Warehouse then oracle OLAP is a definite option for OBIEE.

Repository:

11g repositories are now stored in a compressed format to reduce the storage. As a result, size of RPD file opened and saved in this release is significantly smaller than the size of RPD files from previous releases.

Map view:

11g provides new configuration settings for table, pivot table, graph, and gauge views. The release also introduces a new type called map view.

Generate and Apply XML Patch Files:

It is now possible to generate an XML patch file that contains only the changes made to the RPD. This patch can be then applied to the old version of the repository to create the new version.

You can also use the Oracle BI Server XML utilities to create a generic, XML-based representation of the OBI repository metadata.

Multiuser Development:

 1. MUD projects now explicitly include subject areas (Presentation Catalog). Object security
 permissions no longer affect which presentation objects are included in a checked-out repository.

 2. Set options in the MUD options file to automatically check consistency and equalize during
 merges.

  3. Improved Merge Repository Wizard integration enables a single step input for RPD, no need to

 select repositories one by one and wait for them to load.

  4. Two-way merge feature (full merge without a common parent) enables easier consolidation of
  separate RPD files.

     

Master Detail Linking:

In addition to drill-down and navigation features a new Master-Detail Linking capability has been
introduced which will allow users to click on one table or graph or map to automatically apply filters
to other views within the same Analysis.

    

BI Publisher:

It is now possible with BI Publisher 11g to upload your own local MS Excel files and use them as a
data source for your BI Publisher reports.

Presentation Variables:

In OBIEE11g version it is now possible to assign multiple values to a Presentation Variable.

Metadata Import:

   

If you right click on a Connection Pool in physical layer -- there is a new Import Metadata option  
which is much better than the File à Import menu option when adding further tables because all the
new metadata will get imported directly into the existing Physical Database.

  

This new Import Metadata option will perform as an incremental update of existing tables and
columns. So if a new column is created into database, the tables in the RPD will be incrementally
updated.

 

Terminology Changes:

In 11g release, few terminology has been changed:

iBots have been renamed to agents

Reports have been renamed to analyses

Presentation columns have been renamed to attribute columns

Charts have been renamed to graphs

Archive/Unarchive:

It is now possible archive/unarchive BI Presentation Catalog directly within the dashboard, no need to use the Catalog Manager utility.

Dashboard Prompts:

New dashboard prompt called Variable Prompt will allow to specify custom list of values for the dashboard prompt.

Multiple Subject Areas:

In OBIEE11g Answers can now be sourced from multiple Subject Areas. This means no longer need to cram lots of content into a single Subject Area.

Repository Password:

In 11g release RPD is now have a repository password which encrypts the contents of RPD using a strong encryption algorithm to ensure that repository metadata is secure, including data source credentials in connection pool.

Note: Blank repository password is not allowed in 11g release which was allowed in earlier release (10g).

XMLA Objects:

Drag and drop XMLA objects into the logical layer to automatically create a consistent business model.

Search Capability:

This release provides a mechanism for searching objects in the Oracle BI Presentation Catalog that is similar to a full-text search.

Actions:

Actions will help to navigate to related content or that invoke operations, functions, or processes in external systems.

Conditions:

Conditions return a single Boolean value that is based on the evaluation of an analysis or of a key performance indicator (KPI).