Adding to and Subtracting from Existing Values

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

By default, Essbase overwrites the existing values of the database with the values of the data source, but you can determine how newly loaded data values affect existing data values.

You can use incoming data values to add to or subtract from existing database values. For example, if you load weekly values, you can add them to create monthly values in the database.

Using this option makes recovery more difficult if the database crashes while loading data, although Essbase lists the number of the last row committed in the application log. See Contents of the Application Log.

For block storage databases, set the Commit Row database transaction option to 0 to prevent difficult recoveries. This setting causes Essbase to view the entire load as a single transaction and to commit the data only when the load is complete. See Understanding Isolation Levels.

Using Administration Services Console, you can add to and substract from existing values in block storage and aggregate storage databases. Using MaxL, you can only add to and substract from existing values in aggregate storage databases only.

  To add to or substract from existing data values, use a tool:

ToolTopicLocation
Administration Services

Adding to Data Values

Subtracting from Data Values

Oracle Essbase Administration Services Online Help
MaxL

import data (aggregate storage)

Oracle Essbase Technical Reference