Defining Columns as Data Fields

This section applies to data load only. If you are performing a dimension build, skip this section.

If each record in the data source contains a column for every dimension and one data column, you must define the data column as a data field, as shown in the following example:

Market, Product, Year, Measures, Scenario
Texas   100-10   Jan   Sales     Actual    42
Texas   100-20   Jan   Sales     Actual    82
Texas   100-10   Jan   Sales     Actual    37

You can define only one field in a record as a data field.

  To define a data field, see “Defining Columns as Data Fields” in the Oracle Essbase Administration Services Online Help.