New Features for Oracle BI EE11 g Release 1 (11.1.1.6)

New Features for Oracle BI EE11 g Release 1 (11.1.1.6)

1)      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.

2)      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.

3)      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.

4)      Streamlined MUD Merge Process:  Repository developers using a multi-user 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.

5)      Automated Repository Patching Process:  You can now use an option in the patch rpd command-line utility to enable automated patching without prompting for user input. In addition, new patching-specific rules are applied during patch merges.

6)      Support for Aggregate Persistence in a Cluster

7)      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.

8)      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.