Creating a Copy Data Job

This Job type triggers the copy data action within Hyperion FM.

COPY_DATA Job

  • Login Data

    • The RA Hyperion FM Agent Connection Object object.

  • Application

    • The Hyperion FM application to log into.

  • Source POV

    • The source point of view (POV), three dimensions can be defined: Scenario(S), Year(Y), Period(P), with one entry per dimension.

    For example: S#Actual.Y#2006.P#June

  • Copy Members POV

    • The copy members point of view (POV), two dimensions can be defined: Account(A) and Entity(E), with more entries per dimension

    For example: A#NetProfit.E#Sales

  • Destination POV

    • The destination point of view (POV), three dimensions can be defined: Scenario(S), Year(Y), Period(P), with one entry per dimension

    For example: S#Actual.Y#2006.P#July

  • Mode

    • The mode. Allowed values:

    • Merge
    • Accumulate
    • Replace
  • View

    • The View. Allowed values: 

    • Periodic
    • YTD
  • Multiplier

    • The multiplier.

    If Hyperion FM cannot process the input, the Job will fail and with an according error message.

  • Entity Currency Data

    • The entity currency data.

  • Rates and System Data

    • The rates and system data.

  • Cell Text

    • The cell text.

  • Copy Derived Data

    • The copy derived data.

  • Enable Detailed Logging

    • Whether to enable detailed logging.

Job Status

The status of the Job is "ENDED_OK - ended normally" if the no exception occurs during the call of copy data action through the HFM-API, otherwise it returns "ENDED_NOT_OK" and shows the error in report.

Job Output

The report also shows the parameters passed to the Hyperion FM API call which have been entered in the Automic Web Interface.

If an exception occurs during call of HFM-API, the error message is posted to the report.

If the Job is successful, the message: "Execution of CopyDataAction succeeded" is shown at the end of the report.

Log messages from Hyperion Financial Data Management Enterprise Edition can only be correctly translated/displayed in the Job reports if they are either Latin-9 or UTF-16 encoded.

The Hyperion FM log is transferred to the report directory of the Agent (typically "temp") and registered as output file.

Click in the Reports field to select the log file of the copy data process. The prefix of the file name is "Log" followed by the RunID of the Job.

The report type of the Hyperion FM log in the Automation Engine is "W1".