Subtracting from Data Values

During data loads, by default, Essbase overwrites database values with data-source values. However, you can subtract data-source values from database values. For example, to track available budget by week, you can subtract weekly data expenditures from previous week budget values.

If the subtraction option is used and committed transactions are not used and a failure occurs, recovery may be difficult.

  To subtract from data values:

  1. Open or create a rules file.

  2. Select a 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 Subtract from existing values.

  6. Click OK.

Related Information