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="_".

    Other than the default, only these delimiters are supported: _ (under score), # (hash), & (ampersand), ~ (tilde), % (percentage), ; (semicolon), : (colon), - (dash).

  • 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