Adding to Data Values

During a data load, by default, Essbase overwrites database values with data-source values. However, you can add data-source values to database values. For example, if you load weekly data values, you can add them to create cumulative data values in the database. The data source is not changed.

If you are not using committed transactions, adding data-source values to database values complicates recovery from database interruptions that occur while data is being loaded.

  To add to existing data values during a data load:

  1. Open or create the rules file.

  2. Select a data value field.

  3. Select Options, then Data load settings.

  4. In the Data Load Settings dialog box, select the Data Values tab.

  5. In the Data values node, select Add to existing values.

  6. Click OK.

Related Information