When loading data incrementally, you can specify how missing and zero values in the source data are treated when loading the data into the data load buffer.
For resolving cell conflicts for duplicate cells, you can specify whether to use the last cell loaded into the load buffer.
The data load buffer properties:
ignore_missing_values: Ignores #MI values in the incoming data stream
ignore_zero_values: Ignores zeros in the incoming data stream
aggregate_use_last: Combines duplicate cells by using the value of the cell that was loaded last into the load buffer
Note: | When loading text and date values into an aggregate storage database, use the aggregate_use_last option to help eliminate invalid aggregations. For other guidelines, see Loading, Clearing, and Exporting Text and Date Measures. |
If you use multiple properties in the command and any conflict, the last property listed takes precedence.
To set data load buffer properties, use the alter database MaxL statement with the property grammar.
For example:
alter database AsoSamp.Sample initialize load_buffer with buffer_id 1 property ignore_missing_values, ignore_zero_values;
In Administration Services Console, you can set options to ignore missing values and zero values, and to aggregate duplicate cells by using the value of the last cell loaded, on the Data Load dialog box. See “Data Load Dialog Box” in the Oracle Essbase Administration Services Online Help.