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.