Essbase - Data load in a parent member overwritten by consolidation

Essbase Overview


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.

Tool to set the consolidation

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.

Discover More
Essbase Overview
Essbase - Data Load

Loading data is the process of adding data values to an database from a data source. If the data source is not perfectly formatted, you need a data load rules files to load the data values. You can load...

Share this page:
Follow us:
Task Runner