You use the Data Load Values tab to specify how data values are changed as they are loaded.
In the “Data values” group, you specify how values are loaded:
Overwrite existing values—Replace target values with source values (the default).
Add to existing values—Add source values to target values.
Subtract from existing values: Subtract source values from target values.
Replace all data in the database: Removes the contents of an aggregate storage database and loads the contents of a data load buffer (applicable only to aggregate storage databases).
Note: | For aggregate storage databases, the data values options are also provided in the Aggregate Storage Data Load dialog box. |
You use the “Sign flip” group to reverse data-value signs during data loads. First, you select a dimension (by entering its name in the Dimension box or double-clicking it in the Dimension node). Then, you select On UDA, and specify a UDA. When Essbase encounters the specified UDA, it reverses the sign of the associated member. For example, typically, the sign of an accounts member is plus. But, you can specify that, during data loads, the sign of any accounts member that is assigned a UDA of Expense is changed to minus.
In the “Global select/reject Boolean” group, you specify how selection and rejection criteria are combined:
And—If all fields of a record match the selection and rejection criteria, the record is selected or rejected.
Or—If any field of a record matches the selection or rejection criteria, the record is selected or rejected.
If necessary, click the Outline button to associate the rules file with an outline and populate the dimension node.
“Adding to and Subtracting From Existing Values” in the Oracle Essbase Database Administrator's Guide