copyDataByPointOfView

Copies data from a source POV in a cube to a destination POV in the same or another Enterprise Profitability and Cost Management cube.

Applies to

Enterprise Profitability and Cost Management

Required Roles

Service Administrator

Usage

epmAutomate copyDataByPointOfView SOURCE_POV_NAME TARGET_POV_NAME copyType=ALL_DATA|INPUT SOURCE_CUBE_NAME TARGET_CUBE_NAME [PARAMETER=VALUE] where:
  • SOURCE_POV_NAME is the name of the source POV from which data is to be copied.
  • TARGET_POV_NAME is the name of a valid target POV to which the data from the source is to be copied.
  • copyType identifies the data to be copied from the source POV. Valid values are:
    • ALL_DATA to copy all input and calculated data to the destination POV.
    • INPUT to copy all input data, including driver data, to the destination POV.
  • SOURCE_CUBE_NAME is the name of the cube that contains the source POV.
  • TARGET_CUBE_NAME is the name of the cube that contains the target POV.
  • 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, optionally, 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).

    • createDestPOV=true|false specifies whether to create the target POV if it does not exist. Default is false. You must set this parameter value to true if the destination POV does not exist.

Examples

  • Copy all data to a different POV in the same cube:

    epmAutomate copyDataByPointOfView FY21_Jan_Actual_Working FY22_Jan_Actual_Working ALL_DATA PCM_CLC PCM_CLC povDelimiter="_" createDestPOV=true

  • Copy all data to a different POV in a different cube:

    epmAutomate copyDataByPointOfView FY21_Jan_Actual_Working FY22_Jan_Actual_Working ALL_DATA PCM_CLC PCM_REP povDelimiter="_" createDestPOV=true

  • Copy input data to a different POV in the same cube:

    epmAutomate copyDataByPointOfView FY21_Jan_Actual_Working FY22_Jan_Actual_Working INPUT PCM_CLC PCM_CLC povDelimiter="_" createDestPOV=true

  • Copy input data to a different POV in a different cube:

    epmAutomate copyDataByPointOfView FY21_Jan_Actual_Working FY22_Jan_Actual_Working INPUT PCM_CLC PCM_REP povDelimiter="_" createDestPOV=true