refreshCube

Refreshes the application cube. Typically, you refresh the cube after importing metadata into the application.

The time required to complete a cube refresh operation depends on the changes that you made to the application structure and the impact it has on the cube. For example, a refresh after updating a sparse block storage cube member may not take much time while a cube refresh after updating a dense block storage cube member or an aggregate storage cube member could take a considerable amount of time. You must ensure that the cube refresh operation is complete before the application is backed up during the next maintenance window.

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Enterprise Profitability and Cost Management, Oracle Sales Planning Cloud, and Oracle Strategic Workforce Planning Cloud.

Required Roles

Service Administrator

Usage

epmautomate refreshCube [JOB_NAME] where JOB_NAME, optionally, is the name of a Database Refresh job defined in the application.

Status of the operation is echoed in the console from which the command is run. You can also view the status from the Recent Activity page of the Jobs screen in the application.

Example

epmautomate refreshCube DalyCubeRefresh