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:
Tool | Topic | Location |
---|---|---|
Essbase - Administration Service (EAS) | Aggregating Missing Values During Calculation | Oracle Essbase Administration Services Online Help |
Calculation Script | SET AGGMISSG | Oracle Essbase Technical Reference |
Essbase - MaxL | alter database | Oracle Essbase Technical Reference |
Essbase - 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.