New Features for Oracle BI Metadata Repository Builders

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:

New Features for Oracle BI EE 12c (12.2.1.1.0)

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.

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

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:

  • Logical Level Sequence Numbers for Time Dimensions
  • DISPLAY | SORTKEY Syntax Supported in the SQL ORDER BY expression
  • Oracle Database Fast Application Notification and Fast Connection Failover Supported by Oracle BI Server
  • Generate Fragmented Aggregates in Aggregate Persistence
  • New Command Line Utilities

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