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