1. Working with EPM Automate for Oracle Enterprise Performance Management Cloud
  2. Command Reference
  3. EPM Automate Commands
  4. optimizeASOCube

optimizeASOCube

Optimizes the performance of queries for selecting aggregate views for data extraction from ASO cubes.

This command allows you to perform query optimization operations on ASO cubes in cases where default aggregation is deemed insufficient to meet your data extraction or reporting needs because of large data size. Typical optimization process is as follows:

  • Drop default and query-based aggregations.
  • Start query tracking.
  • Run sample queries from Profitability and Cost Management Query Manager, Oracle Smart View for Office, or Data Management, and any other MDX queries representative of the type of queries for which optimization is desired to train Oracle Essbase.
  • Create aggregation based on optimized or default queries.

Applies to

Profitability and Cost Management

Required Roles

Service Administrator, Power User

Usage

epmautomate optimizeASOCube APPLICATION_NAME OPTIMIZATION_TYPE where:

  • APPLICATION_NAME is the name of the Profitability and Cost Management application to which the ASO cube belongs.
  • OPTIMIZATION_TYPE is a cube optimization operation. Acceptable values are:
    • clearAggregations which removes default and query-based views.
    • createAggregations which creates default Essbase aggregate views. Use this option to perform default aggregation instead of query-based aggregation
    • startQueryTracking which starts query tracking.
    • stopQueryTracking which stops query tracking. Use this option to stop Essbase from collecting optimization information. Essbase continues to collect optimization information until you stop query tracking or stop Essbase. Essbase can aggregate views based on data collected until query tracking is stopped.
    • createQBOAggregations which creates Essbase aggregate views based on the optimized queries that you run after enabling query tracking.

Examples

  • Drop default and query-based aggregate views:

    epmautomate optimizeASOCube BksML12 clearAggregations

  • Start query tracking

    epmautomate optimizeASOCube BksML12 startQueryTracking

  • Create Essbase aggregate views based on the optimized queries that you run after starting query tracking:

    epmautomate optimizeASOCube BksML12 createQBOAggregations