New Features for Oracle BI Metadata Repository Builders

This preface describes changes to metadata repository features for Oracle Business Intelligence Enterprise Edition 12c Release 1 (12.2.1).

This preface contains the following topics:

New Features for Oracle BI EE 12c Release (12.2.1)

New metadata repository features in Oracle BI EE 12c Release (12.2.1) include:

Logical Level Sequence Numbers for Time Dimensions

The Sequence Numbers tab has been added to the Logical Level dialog. The new tab allows you to add absolute or relative sequence numbers to time dimensions. These mappings provides direct column references in the Time dimension table, which creates a query that is easier for Oracle BI Server to execute against the data source. See "Adding Sequence Numbers to a Time Dimension's Logical Level" for more information.

DISPLAY | SORTKEY Syntax Supported in the SQL ORDER BY Expression

The Oracle BI Server now 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. For more information, see "ORDER BY Clause Syntax."

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" for more information.

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 query's Create statement. See "Writing the Create Aggregates Specification" for more information.

New Command Line Utilities

Several command line utilities have been added. See the following topics for more information: