When an outline is saved, the database may be restructured. For information about managing database restructuring, see the Oracle Essbase Database Administrator's Guide.
In the Restructure Database dialog box, you specify how data values are handled during restructures by selecting one of the following options:
All data—All data values are preserved.
Level 0 data—Only level 0 (leaf node) values are preserved. If all data required for calculation resides in level 0 members, you should select this option. If the option is selected, all upper-level blocks are deleted before the database is restructured. Therefore, the disk space required for restructuring is reduced, and calculation time is improved. When the database is recalculated, the upper-level blocks are re-created.
Input data—Only the blocks that contain the data that is being loaded are preserved. However, all blocks (both upper-and lower-level) that contain loaded data are preserved.
Discard all data—All data values are cleared.
If Hybrid Analysis is enabled, the “Warn if restructuring affects Hybrid Analysis” option is displayed. If you want to see warnings on how modifications to the Essbase outline may affect queries that run within the context of the Hybrid Analysis data source, select the option.
“Optimizing Database Restructuring” in the Oracle Essbase Database Administrator's Guide
increstruc (essbase.cfg) in the Oracle Essbase Technical Reference
setdbstateitem (ESSCMD) in the Oracle Essbase Technical Reference