Creating an Extract Data to Flat File Job

This Job type triggers the execution of the extract data to flat file action in Hyperion FM and as a result writes the extracted data into a file. The file is on the host where the Agent is located.

Be aware that "Extract Data" influences "Line Item Option", "Extract Dynamic Accounts", "Calculated Data" and "Derived Data". When "Extract Data" is unchecked these controls are disabled and cannot be set.

EXTRACT_DATA_TO_FLAT_FILE Job

  • Login Data

    • The RA Hyperion FM Agent Connection Object object.

  • Application

    • The Hyperion FM application to log into.

  • POV

    • The point of view (POV) which contains at least Scenario, Year, Period, Entity and Value.

    Format: S#<SCENARIO>.Y#<YEAR>.P#<PERIOD>.E#<ENTITY>.V#<VALUE>

  • File Name

    • The file where extracted data is stored. This path refers to the file system on the Agent host computer (which is also the Hyperion FM file system).

  • Delimiter Character

    • The delimiter character. Allowed values:

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

    • The extract format. Allowed values:

    • Flat file without header (default)
    • Flat file with header
  • Extract File Prefix

    • The prefix.

  • Phased Submission Group Data

    • When checked, phased submission group data is set.
    Default: Unchecked

  • Cell Description

    • When checked, cells are described.
    Default: Unchecked

  • Extract Data

    • When checked, data is extracted.
    Default: Unchecked

  • Extract Dynamic Accounts

    • When checked, dynamic accounts are extracted.
    Default: Unchecked

  • Calculated Data

    • When checked, data is calculated.
    Default: Unchecked

  • Derived Data

    • When checked, data is derived.
    Default: Unchecked

  • Line Item Option

    • The line item option. Allowed values:

    • None (default)
    • Individual line items
    • Total summary for cell

Job Status

The status of the Job is "ENDED_OK - ended normally" if the status is COMPLETED_SUCCESSFULLY or COMPLETED_WITH_WARNINGS. The Job status is "ENDED_NOT_OK - aborted" if the extract status is FAILED or STOPPED.

Job Output

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

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.

All entries have a time stamp. The HFM log is transferred to the report directory of the Agent (typically "temp") and registered as output file.

The prefix of 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".