Work with Oracle EPM Cloud Data Sources

Which Oracle EPM Business Processes Does Oracle Analytics Support?

When you integrate Oracle Analytics with Oracle Enterprise Performance Management, make sure that you're connecting to one of the supported business processes:

Oracle Analytics supports:

Financial Consolidation and Close
FreeForm
Planning and Planning Modules
Profitability and Cost Management
Tax Reporting

Oracle Analytics doesn't support:

Account Reconciliation
Enterprise Data Management Cloud
Narrative Reporting

About Connecting to an Oracle EPM Cloud Data Source

This topic provides information about connecting to the Oracle EPM Cloud data source that you want to use in your semantic model.

What is the System Connection Requirement?

Data source connections with the System connection checkbox selected are available for semantic model development. By default, these connections are displayed in a semantic model's Connections tab.

If you create an EPM Cloud data source connection from the Oracle Analytics Home page's create Connection option, be sure to select the System connection checkbox to make the connection available when you develop semantic models. You can't edit the data source's System connection option after setting up the connection.

See About Semantic Model Data Source Connections.

Which Oracle EPM Business Processes are Supported in Semantic Modeler?

For a list of the Oracle EPM Cloud business processes that Oracle Analytics supports, see Which Oracle EPM Business Processes Does Oracle Analytics Support?

Note that Oracle Analytics doesn't support Oracle EPM on premises applications.

How Do I Create the Connection?

Use this topic to create your Oracle EPM connection, making sure to select the System connection checkbox to make the connection available for semantic models: Connect to Oracle EPM Cloud.

About Importing Metadata From Oracle EPM Cloud Planning Data Sources

Use this topic to understand how Semantic Modeler structures the data you import from an Oracle EPM Cloud Planning data source.

When you import an Oracle EPM Cloud Planning data source into the semantic model:

The imported data source contains multiple value columns to support measures of different data types.
Some measures specific to Oracle EPM Cloud Financial Consolidation and Close aren't imported with Oracle EPM Cloud Planning data sources.
The Attribute property has additional sub-properties, such as IsReadOnly. These properties are also exposed as additional columns.

All Oracle EPM Cloud Planning dimensions are modeled as parent-child hierarchies in the physical layer. Shared members, alternate hierarchies, and unbalanced hierarchies are supported.

Dimension member properties are exposed as columns such as Name, Description, and ShortName. An additional column called Sort Order is also displayed for each dimension. This column contains custom sort information retrieved from the data source.

Each Oracle EPM Cloud Planning dimension has a corresponding Point of View (POV) value that provides customized information for different users. This POV value is used as the Default Member in the physical hierarchy's properties upon import. You might need to update the default values according to the users' needs.

Be careful to not set the Default Member property to All for Oracle EPM Cloud Planning hierarchies.

About Query Support for Oracle EPM Cloud Data Sources

Semantic Modeler supports member queries (dimensional browsing) and data queries (measure analysis) for Oracle EPM Cloud Financial Management and Planning data sources.

Use the EVALUATE_PREDICATE Logical SQL function to access these functions specific to Oracle EPM Cloud Financial Management and Planning:

PeriodOffset used to access prior or future periods through an offset.
SuppressDerived, SuppressInvalidIntersection, SuppressNoAccess, SuppressZero, SuppressError NA suppression functions specific to Oracle EPM Cloud Financial Management.
Base to return the leaf members below a given ancestor member.
CommonChildren.
User-defined functions.

The Oracle Analytics query engine supports PERF_PREFER_SUPPRESS_EMPTY_TUPLES for inserting the SuppressMissing function into the Oracle EPM Cloud Financial Management or Planning data query to suppress missing cells. The PERF_PREFER_SUPPRESS_EMPTY_TUPLES function controls whether empty tuples with empty cell values are eliminated. PERF_PREFER_SUPPRESS_EMPTY_TUPLES doesn't change the null suppression behavior on the final result set.

There is no native support for time series functions. Time series functions are only supported through data modeling.

Add Oracle EPM Cloud Cube Tables to the Physical Layer

From the Oracle EPM Cloud connection, you can drag and drop cube tables to add them to the semantic model's physical layer.

You need to create one database in the physical layer for each cube or set of cubes.

Dragging and dropping a cube table from the data source connection to the physical database populates some of the database's features, the query features, and connection pools. You can adjust these settings as needed. You can add query limits for application roles to the database.

See About Connecting to an Oracle EPM Cloud Data Source.

On the Home page, click Navigator and then click Semantic Models.
In the Semantic Models page, click a semantic model to open it.
Click Physical Layer .
In the Physical Layer pane click Create and then click Create Database.
In Create Database, go to Name and type a name. In the Database Type field select Oracle EPM Cloud. Click OK.
The new database's Tables tab is displayed.
In the Tables tab, click Connections and in the connections pane, expand the Oracle EPM Cloud connection and browse or search for the cube table to add to the physical database.
Drag the cube table to the physical database and drop it into the Tables list.
Click the Connection Pools tab and verify that your database and connection pool settings are correct.
Click the Tables tab to inspect and confirm the imported physical columns and hierarchical levels.
Click Save.