Learn about new features in this release.
This preface describes changes to metadata repository features for Oracle Business Intelligence Enterprise Edition 12c Release.
This preface contains the following topics:
This preface describes changes to metadata repository features for Oracle Business Intelligence Enterprise Edition 12c (12.2.1.1.0).
New metadata repository features in Oracle BI EE 12c Release (12.2.1.1.0) include:
Data Driven Fragment Selection in Logical Table Sources
You can improve the performance of models using fragmented logical table sources by enabling the Data Driven Fragment Selection option. See Enabling Data Driven Fragment Selection.
This preface describes changes to the Oracle BI metadata repository for Oracle Business Intelligence Enterprise Edition 12c Release 1 (12.2.1).
New metadata repository features in Oracle BI EE 12c Release (12.2.1) include:
DISPLAY
| SORTKEY
Syntax Supported in the SQL ORDER BY
expressionLogical Level Sequence Numbers for Time Dimensions
The Logical Level dialog has a new Sequence Numbers tab. You can add absolute or relative sequence numbers to time dimensions in the new tab. These mappings provide direct column references in the Time dimension table that creates a query that Oracle BI Server can execute against the data source. See Adding Sequence Numbers to a Time Dimension's Logical Level.
DISPLAY | SORTKEY Syntax Supported in the SQL ORDER BY Expression
The Oracle BI Server accepts the DISPLAY
and SORTKEY
keywords in the SQL ORDER BY
expression. You can use the DISPLAY
keyword to override a logical column's assigned sort order column. See ORDER BY Clause Syntax in Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition.
Oracle Database Fast Application Notification and Fast Connection Failover Supported by Oracle BI Server
The Oracle BI Server supports the Fast Application Notification (FAN) event and Fast Connection Failover (FCF) Oracle Database configuration. Fast Connection Failover enables quick failover when the data source's Oracle database is not available. See Oracle Database Fast Application Notification and Fast Connection Failover.
Generate Fragmented Aggregates in Aggregate Persistence
The aggregate persistence functionality has been enhanced to generate fragmented aggregates from a manually written aggregate specification. You can generate fragmented aggregates by adding a Where clause to the Logical SQL CREATE
statement. See Writing the Create Aggregates Specification.
New Command Line Utilities
New command line utilities are available. See the following topics: