Moving from 11.1.1.3 or 11.1.1.5 to 11.1.1.6

Please refer:

http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH

New Features for Oracle BI EE 11g Release 1 (11.1.1.6)

New metadata repository features in Oracle BI EE 11g Release 1 (11.1.1.6) include:

• Ability to Limit and Offset Rows Returned
• Identify Query Candidates with Oracle BI Summary Advisor
• Integrate the Administration Tool with a Third-Party Source Control Management System
• Streamlined MUD Merge Process
• Automated Repository Patching Process
• Support for Aggregate Persistence in a Cluster
• FIRST_PERIOD and LAST_PERIOD Time Series Functions
• Ability to Print the Physical and Business Model Diagrams

Ability to Limit and Offset Rows Returned

You can use the FETCH and OFFSET clauses to constrain the number of rows returned by the SELECT statement and to offset the returned rows by a given number. Both clauses are optional and can be used together, or independently. See "Limiting and Offsetting Rows Returned" for more information.

Identify Query Candidates with Oracle BI Summary Advisor

If you are running Oracle Business Intelligence on the Oracle Exalytics Machine, you can use the Oracle BI Summary Advisor feature to identify which aggregates will increase query performance. Summary Advisor intelligently recommends an optimal list of aggregate tables based on query patterns that will achieve maximum query performance gain while meeting specific resource constraints. See "Using Oracle BI Summary Advisor to Identify Query Candidates for Aggregation" for more information.

Integrate the Administration Tool with a Third-Party Source Control Management System

As an alternative to using a MUD environment, you can choose to save your repository in MDS XML format and integrate the Administration Tool with a third-party source control management system. See Chapter 4, "Using a Source Control Management System for Repository Development" for more information.

Streamlined MUD Merge Process

Repository developers using a multiuser development (MUD) environment can now merge and publish changes in a single step, rather than merging local changes and then publishing changes as two separate steps. They can also perform subset refreshes to perform incremental local merges with the master repository. See "Publishing Changes to Multiuser Development Repository Projects" for more information.

Automated Repository Patching Process

You can now use an option in the patchrpd command-line utility to enable automated patching without prompting for user input. In addition, new patching-specific rules are applied during patch merges. See "Merge Rules and Behavior for Patch Merges" for more information.

Support for Aggregate Persistence in a Cluster

You can now use the aggregate persistence feature in a clustered environment. See "Running the Aggregate Specification Against the Oracle BI Server" for more information.

FIRST_PERIOD and LAST_PERIOD Time Series Functions

You can now use the FIRST_PERIOD and LAST_PERIOD functions to compute the first and last value of an expression using the chronological key rather than the primary level key. See "FIRST_PERIOD" and "LAST_PERIOD" for more information.

Ability to Print the Physical and Business Model Diagrams

You can now use Print Preview and Print to view and print the Physical and Business Model Diagrams in the Administration Tool. See "Using the Physical and Business Model Diagrams" for more information.