About
If you work with a block storage database (not aggregate storage) and then you load data into a parent member, when you calculate the database, the consolidation of the children’s data values can overwrite the parent data value. To prevent overwriting:
- If possible, do not load data directly into a parent.
- If you must load data into a parent member, ensure that Essbase knows not to consolidate #MISSING values from the children of the parent into the parent.
Articles Related
Tool to set the consolidation
| Tool | Topic | Location |
|---|---|---|
| Essbase Administration Services | Aggregating Missing Values During Calculation | Oracle Essbase Administration Services Online Help |
| Calculation Script | SET AGGMISSG | Oracle Essbase Technical Reference |
| Maxl | alter database | Oracle Essbase Technical Reference |
| Esscmd | SETDBSTATEITEM | Oracle Essbase Technical Reference |
The methods in this table work only if the child values are empty (#MISSING). If the children have data values, the data values overwrite the data values of the parent. See Consolidating #MISSING Values.