Changes in This Release for Oracle OLAP User's Guide

Connecting to a database using a service name.

See "Defining a Database Connection".

Specifying an attachment mode when connecting an analytic workspace to an Oracle Database.

See "Showing the Analytic Workspace Attachment Modes".

Creating calculated measures that are based on OBIEE-compatible SQL function expressions.

If this feature is enabled, then Analytic Workspace Manager automatically creates additional calculated measures as needed for processing a calculated measure that you create. The cube that contains the calculated measures is suitable for exporting to Oracle Business Intelligence Enterprise Edition (OBIEE). You can export a cube to OBIEE by using the Export to OBIEE Administrator plug-in.

See "Creating Cubes" and "Creating Calculated Measures".

Creating a fact view with a measure dimension table.

The fact view pivots a fact table so that the measures identify rows instead of columns.

See "Creating Measure Dimensions".

Creating a measure dimension.

You can now create a measure dimension, which has measures as dimension members. Dimensions now have a Class type, which is either None or Measure.

See "Creating Measure Dimensions".

Saving the SQL of a mapping to the clipboard or to a file.

See "Mapping Cubes"

Specifying the aggregate functions SUM, MAX, MIN, AVG, and COUNT when mapping a cube to data sources.

See "Aggregate Functions".

Partitioning a cube on multiple levels of a dimension hierarchy.

See "Partitioning a Cube".

Saving an object definition to, or create an object from, a table.

Previously, you could save an object definition as an XML template in a file. You can now save an XML template in a database table. You can use the XML template to re-create the dimensional objects.

See "Saving and Re-Creating Dimensional Objects with Object Definitions".

Copying and pasting objects.

You can now copy objects such as an analytic workspace, a cube, a dimension, or a measure and paste that object in an appropriate location.

See "Copying and Pasting Dimensional Objects".

Joining cubes to tables and views.

Oracle Database 12c introduces the CUBE JOIN operation. This operation improves the performance of joining a cube to a table or a view.

See "Joining Cubes to Tables and Views".

Desupport of Common Warehouse Metamodel (CWM) for Oracle OLAP

Data security policies use Oracle Real Application Security.

When you create data security policies for cubes or dimensions, Oracle OLAP uses Oracle Real Application Security (ORAS) instead of Extensible Data Security (XDS), which it used in Oracle Database 11g releases. When you upgrade Oracle Database from an 11g release to 12c, then your XDS data security policies are automatically converted to ORAS.

Some differences in the data security implementation in 12c are the following:

• Only the owner of an object can create a data security policy or OLAP data security role. In 11g, the owner and anyone who had write privileges for the object could create a data security policy or OLAP data security role.

• You can disable the data security policy for a dimension or a cube and then enable it again.

• You can have create more than one OLAP data security role; however, you can only add one data security role to a dimension or a cube. In 11g, you could add more than one.

Viewing information about the partitions of a cube.

The Partition Member Analysis subtab of the Partitioning properties of a cube displays information about the partitioning of the cube. This information replaces the Cube Partitioning Advisor of previous releases.

Oracle Enterprise Manager Cloud Control (Cloud Control)

In previous releases of Oracle Database, you used Oracle Enterprise Manager Database Control (Database Control) to manage database performance tuning from a graphical user interface. In this release, you can use the Cloud Control graphical user interface.

You must install Cloud Control separately from Oracle Database.