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 metadata repository features in Oracle BI EE 12c Release (12.2.1) include:
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.
The Oracle BI Server now accepts the
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."
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.
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.
Several command line utilities have been added. See the following topics for more information: