Importing Data from a File

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

Table 44. Import Data from File Options

OptionDescription

Data Import Format

Choose a data import file format:

  • Planning—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—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.