Why OBIEE 11G is preferrable?

OBIEE 11g is more preferable than OBIEE 10g as it has got remarkable features which are as follows:

Multiple Subject Areas:
In this release, you can work with multiple subject areas. In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you can include additional subject areas that are related to the primary subject area with which to work.
Interaction with Other Oracle Products: - Oracle BI Publisher is a fully integrated member of the Oracle BI EE suite by default.
– Oracle Hyperion Smart View is available for download from the Oracle BI EE Home page.
– The integration of Oracle BI EE with Oracle Business Intelligence Add-in for Microsoft Office has been enhanced.

Enhanced Drill-down Functionality:
In this release, the drill-down functionality is been modified so that one can drill-in place and see the impact without effecting the other values of the same attribute.
eg:  The drill-down functionality is been applied on a column(say ‘Year’).
If the end-user selects any value (say ‘2010’), the drill-in place occurs on that column and shows the child level attributes for that particular value without effecting the report structure wherein the remaining values of the same column are undisturbed.
Web Catalog Migration:
Another easier, more attractive approach is to abandon the file system copy altogether and use the Catalog Manager to facilitate the movement of only the shared folder, or some portion of it, from Dev to Prod. A new enhancement in 11g is the ability to do web catalog Archive and Unarchive operations from within Answers.
Authorization:
Authorization in 10g was achieved using a combination of Users, Groups and association of privileges and object permissions to users and Groups. Two keys changes to Authorization in OBIEE 11g are:
  1. Application Roles
  2. Policies / Permission Groups
Application Roles are introduced in OBIEE 11g. An application role is specific to the application. They can be mapped to other application roles defined in the same application scope and also to enterprise users or groups, and they are used in authorization decisions. Application roles in 11g take the place of Groups in 10g within OBIEE application. In OBIEE 10g, any changes to corporate LDAP groups require a corresponding change to Groups and their permission assignment. In OBIEE 11g, Application roles provide insulation between permission definitions and corporate LDAP Groups. Permissions are defined at Application Role level and changes to LDAP groups just require a reassignment of the Group to the Application Roles.
Permissions and privileges are assigned to Application Roles and users in OBIEE 11g compared to Groups and Users in 10g.
Application policies are the authorization policies that an application relies upon for controlling access to its resources. An Application Role is defined by the Application Policy.
In OBIEE 10g, the permission to manage repositories and Impersonation were assigned to “Administrators” group with no control to separate these permissions in the Administrators group. Hence user “Administrator” also had the permission to impersonate. In OBI11g, BIAdministrator does not have the permission to impersonate. This gives more flexibility to have multiple users perform different administrative functions.
New Column Type and Related Operations: In this release, new column type Hierarchical Column is introduced.
Hierarchical Column holds data values that are organized and support the following hierarchy kinds:
– Level-based hierarchy,
– Parent-child hierarchy,
– Ragged or unbalanced hierarchy (in which all the lowest-level members do not have the same depth),
– Skip-level hierarchy (in which certain members do not have values for certain higher levels).

Enhancements to Views: Several of the view types have been enhanced, including:
– New Table and pivot table functionality, hierarchical columns and drag and drop columns.
– New Slider functionality on graphs and gauges views.
– New Map view type to presents data in spatial form.
– New Master-detail linking of views, which enable to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views.


SQL Functions for Time Series Calculations
PERIODROLLING is a new function that computes the sum of a measure over the period starting x units of time and ending y units of time from the current time.
AGGREGATE AT is a new function that aggregates columns based on the level or levels specified
AGO is a time series aggregation function that calculates the aggregated value from the current time back to a specified time period. In this release, the time_level argument is optional, and there are additional syntax changes.
TODATE is a time series aggregation function that aggregates a measure attribute from the beginning of a specified time period to the currently displayed time. The syntax for this function has changed in this release.

Embedded Database Functions: New supported functions EVALUATE, EVALUATE_AGGR, and EVALUATE_PREDICATE can be directly calling database functions from either Oracle Business Intelligence, or by using a Logical column (in the Logical Table source) within the metadata repository.
Key Performance Indicators (KPIs): In this release, you can create KPIs to represent business measures or metrics that you want to monitor, improve, and use to evaluate the performance of the objectives and initiatives that comprise levels of organizational strategy.
KPIs have measurable values that usually vary with time, have targets to determine a score and performance status include dimensions to allow for more specific analysis, and can be compared over time for trending purposes and to identify performance patterns.
Oracle Scorecard and Strategy Management: In this release, you can use Oracle Scorecard and Strategy Management to articulate, evaluate (scorecard), and evolve the performance of your organization or key business areas. You can use Oracle Scorecard and Strategy Management to define, depict, and monitor the progress of the strategic goals and requirements (objectives) key to corporate functions, and the tasks and projects (initiatives) that are required to achieve those goals. Oracle Scorecard and Strategy Management also enables you to either align your objectives and initiatives with traditional balanced scorecard perspectives, or to create your own to reflect your fundamental business competencies.