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.
