Setting the All Data Types Load Method

You can select the method to use when loading metadata and data for Account, Period, Year, Scenario, Version, Currency, Entity, user-defined dimensions, attributes, UDAs, exchange rates, Smart Lists, and planning unit hierarchies.

Note:

To load numeric data, use the Numeric Data Only load method.

Select the Setup tab, and then under Register, select Target Application.
In Target Application, in the Target Application summary grid, click Add, and then select either Local or Cloud.

Available options are Cloud (for a Cloud deployment) or Local (for an on-premise deployment).
In Target Application under Application Options, from the Load Method drop-down, select all data types with security.
Available load method descriptions:
- All data types with auto-increment of line item.
  This method requires that you define the data and driver dimensions, and unique identifiers for the Oracle Enterprise Performance Management Cloud application. You define data load and driver dimension in the Data Dimension for Auto-Increment Line Item field and Driver Dimension for Auto-Increment Line Item field on the Target Options tab in the Data Load Rule.
  
  For detailed information on this option, see Loading Incremental Data using the LINEITEM Flag to an EPM Application.
- Numeric—Loads numeric data only. Oracle Hyperion Planning data security is not enforced in this method.
- all data types with security— Loads Numeric, Text, Smartlist, Date data types. If the Planning administrator loads data, Planning data security is not enforced. If a Planning non-administrator user loads data, then Planning data security is enforced.
  
  The data is loaded in chunks of 500K cells.
From the Date Format drop-down, specify the format of the date data:
- DD-MM-YYYY
- MM-DD-YYYY
- YYYY-MM-DD
Click Save.