Creating a Load Data Job

This action loads data from a file into Hyperion FM. If the Agent is not running the Browse button is disabled.

Be aware that "File contains process management data" cannot be used together with "File contains ownership data" and/or "Accumulate within File". Also, if you check "File contains process management data", "Load Mode" will only support the "Replace" and "Merge" options.

LOAD_DATA Job

  • Login Data

    • The RA Hyperion FM Agent Connection Object object.

  • Application

    • The Hyperion FM application to log into.

  • File Name

    • The name of the file to load (with a .dat extension). To browse the Agent file system (which is also the Hyperion FM file system) for the file, use the Browse button. If there is no connection to the Agent, the Browse button is disabled.

  • Delimiter Character

    • The delimiter character. Allowed values:

    • ; (default)
    • ,
    • ~
    • @
    • #
    • $
    • %
    • ^
    • &
    • |
    • :
    • ?
    • \
  • Scan only

    • When checked, a scan is done, but the list is not loaded.


    Default: Unchecked
  • File contains: Process management data

    • When checked, the file will contain process management data.
    Default: Unchecked

    "File contains process management data" cannot be used together with "File contains ownership data" and/or "Accumulate within File".

    If you check "File contains process management data", "Load Mode" will only support the "Merge" and "Replace" options.

  • Load Mode

    • Allows you to select the load mode: 

    • Merge
    • Replace
    • Replace by security
    • Accumulate
  • File contains: Ownership data

    • When checked, the file will contain ownership data.
    Default: Unchecked

  • Accumulate within File

    • When checked, the file will accumulate within the file.
    Default: Unchecked

Job Status

The load process may run for a long time. After the process has been triggered the status is polled every 3 seconds. The Job remains active until the load process has finished.

The status of the Job is "ENDED_OK - ended normally" if the status is COMPLETED. The Job status is "ENDED_NOT_OK - aborted" if the load status is ABORTED, NOT_RESPONDING or STOPPED.

Further it is "ENDED_NOT_OK - aborted" if the wrong load mode (either "Replace by security" or "Accumulate") is selected for "File contains process management data".

If you choose "Replace by security" or "Accumulate" then the JOBS will ENDED_NOT_OK with an error like "Error: Invalid duplicate handling 'Replace by Security'".

Job Output

The Job report contains the Job parameters and the result of the load action.

Every 3 seconds (status check) the progress of the load task is written to the report.

In addition the remote status of the Job which is updated in the Job check interval will show the completion rate in percent for long running Jobs.

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 log of the load process is added in a new report. The file name is "Log" followed by the RunID of the Job.

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