Using a Job

You can use a job of type Copy POV that was created in the PCM Agent to supply predefined parameters for this command.

Any required parameter not saved in the job definition must be supplied on the command line, and any parameter in the job definition can be overridden on the command line.

Usage

epmAutomate copyDataByPointOfView [jobName=JOB_NAME] [sourcePOVName=SOURCE_POV_NAME] [destPOVName=TARGET_POV_NAME] [copyType=ALL_DATA|INPUT] [sourceCubeName=SOURCE_CUBE_NAME] [destCubeName=TARGET_CUBE_NAME] [PARAMETER=VALUE] where:
  • jobName=JOB_NAME is the name of the job that should be used to copy data. Parameter values for copying data are accepted from this job. Required if parameter values are not specified on the command line. Default is Copy POV.
  • sourcePOVName=SOURCE_POV_NAME, optionally, is the name of the source POV from which data is to be copied.
  • destPOVName=TARGET_POV_NAME, optionally, is the name of a valid target POV to which the data from the source is to be copied.
  • copyType, optionally, 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.
  • sourceCubeName=SOURCE_CUBE_NAME, optionally, is the name of the cube that contains the source POV.
  • destCubeName=TARGET_CUBE_NAME, optionally, 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), ~ (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 target POV does not exist.

Examples

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

    epmAutomate copyDataByPointOfView jobName=copyData

  • Copy all data to a different POV in the same cube but override some parameter values:

    epmAutomate copyDataByPointOfView jobName=copyData sourcePOVName=FY21_Jan_Actual_Working sourceCubeName=PCM_CLC destCubeName=PCM_CLC povDelimiter="_" createDestPOV=true