Importing Data from a File

To import data, the load dimension must be selected in the Dimension list.

Table 5-18 Import Data from File Options

Option	Description
Data Import Format	Choose a data import file format: Planning—Oracle Hyperion Planning file format Note: If data is exported to a file in Planning format, you can use Notepad to change the database name in the file; for example, ASOCube, and then import the data file into the aggregate storage outline provided all dimensions exist in the aggregate storage outline. Essbase—Oracle Essbase file format. (exported by an on-premises product). These files can be formatted in either Cell list or Column list format. Cell list format specifies a single cell value for each record, whereas Column list format specifies multiple cell values for each record. For example, if you specify Time on the column, you might have the values Jan, Feb, Mar, and so forth on the column, with 12 values for each record (that is, one for each month). Conversely, the Cell list equivalent would contain 12 records, one for each month. For information on exporting files from Essbase, see the on-premises Oracle Essbase Administration Services Online Help.
Dimension to Import	For a Planning data import format, select the dimension into which to load data, whose member fields correspond to the header record in the data file. This dimension must exist in the application.
Plan Type	For an Essbase data import format, select the plan type into which to import the data.
Data File to Import	Specify the data load input file which contains a header record and data records.
Driver Member Specification	For a Planning data import format, enter the driver members specified for the import dimension. If you leave this field empty and you specified import and driver members on the Data Load Administration window, those settings are used for the import. Conversely, values that you enter here override those on the Data Load Administration window.
Date Format	Choose an import date format: MM-DD-YYYY DD-MM-YYYY YYYY-MM-DD
Clear Essbase Data	Clears an Essbase block before performing an import. For example: e2,IDescendants(Account_Total),"FY13,Current, BU Version_1,Jan,Local",Plan1 Note: If a data value exists in a cell and the imported data does not have a value for that cell, the existing data is not overwritten. To overwrite existing data with a #missing value, the data block must be cleared first (all cells will be #missing) and then data should be imported into these cells.