Setting the Parameters for Data Load Rules

The parameters used to execute a batch script for data load rules are:

Table 37. Parameters for Data Load Rules

ParameterValue
UserUsername
PasswordPassword or –f:Password file name
IMPORT_FROM_SOURCEY or N
EXPORT_TO_TARGETY or N
EXPORT_MODE

Essbase and Planning applications export modes are:

  • STORE_DATA

  • ADD_DATA

  • SUBTRACT_DATA

  • OVERRIDE_ALL_DATA

Note:

The EXPORT_MODE is not supported for custom target applications.

The Hyperion Financial Management application export mode is:

  • Accumulate

  • Replace

  • Merge

  • Replace_By_Security

IMPORT_MODE

  • Snapshot

  • Incremental

  • Full Refresh

The file-based source system export modes are

  • Append

  • Replace

START_PERIOD_NAMEPeriod Name or POV when the POV specified period value is retrieved from the period profile.
END_PERIOD_NAMEPeriod Name or POV when the POV specified period value is retrieved from the period profile.
SYNC_MODESYNC / ASYNC

  • SYNC—Process runs immediately and control returns when process completes.

  • ASYNC—When the ODI job is submitted, control returns. The load process continues to execute in ODI.