clearDataByPointOfView

Clears data for a specific POV for an Enterprise Profitability and Cost Management cube.

Applies to

Enterprise Profitability and Cost Management

Required Roles

Service Administrator

Usage

epmAutomate clearDataByPointOfView POV_NAME [cubeName=CUBE_NAME] [PARAMETER=VALUE] where:
  • POV_NAME is the name of a POV in the application.
  • cubeName, optionally, is the name of the cube in which data is to be cleared. Default is PCM_CLC.
  • PARAMETER=VALUE indicates optional runtime parameters and their values. Specify as many parameter and value pairings as the process requires. Valid parameters and their values:
    • povDelimiter is the delimiter used in POV values. Default is :: (double Colon). This value must be enclosed in double quotation marks. Example: povDelimiter="_"
    • clearInput=true|false specifies whether to clear input data. Default is false.
    • clearAllocatedValues=true|false specifies whether to clear allocated values. Default is false.
    • clearAdjustmentValues=true|false specifies whether to clear adjustment values. Default is false.

      Note:

      • Parameter values (true or false) must be in all lower case.
      • At least one of clearInput, clearAllocatedValues or clearAdjustmentValues parameters must be set to true.

Examples

  • Clear data from a POV in the default PCM_CLC cube using the default POV delimiter:

    epmAutomate clearDataByPointOfView FY21::Jan::Actual::Working clearInput=true clearAllocatedValues=true clearAdjustmentValues=true

  • Clear input data and allocated values from a POV in a specific cube using a custom POV delimiter:

    epmAutomate clearDataByPointOfView FY21_Jan_Actual_Working cubeName=PCM_REP povDelimiter="_" clearInput=true clearAllocatedValues=true

  • Clear input data from a POV in a specific cube using a custom POV delimiter:

    epmAutomate clearDataByPointOfView FY21:Jan:Actual:Working cubeName=PCM_REP povDelimiter=":" clearInput=true