1. Using Oracle Essbase
  2. Manage Application and Cube Artifacts and Settings
  3. Set Advanced Cube Properties

Set Advanced Cube Properties

If the current cube is a block storage cube, then you can select whether to enable the following options:

  • Aggregate missing values: If you never load data at parent levels, selecting this option may improve calculation performance. If this option is selected and you load data at the parent level, then the parent-level values are replaced by the results of the cube consolidation, even if the results are #MISSING values.
  • Create blocks on equations: If this option is selected, then when you assign a non-constant value to a member combination for which no data block exists, a data block is created.

    Selecting this option can produce a very large cube.

  • Two-Pass calculation: If this option is selected, then after a default calculation, members that are tagged as two-pass are recalculated.
  1. On the Applications page, expand the application.
  2. From the Actions menu, to the right of the cube name, click Inspect.
  3. Select the Settings tab.
  4. Select Calculation.
  5. Select the options that you want.
  6. Click Save.