Set Calculation-Related Cube Properties

Using the Essbase web interface, you can set calculation properties for the current Essbase block storage (BSO) cube, by selecting or deselecting options in the database settings. You can select whether to aggregate missing values, create blocks on equations, or enable two-pass calculation.

• 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. Do not use two-pass calculation for hybrid mode cubes. Use solve order instead.

1. Navigate to the Settings tab.

   In the Redwood Interface, on the Home page, open the application and then open the database (cube).

2. Click the Settings tab.
3. Click Calculation.
4. Select the options that you want.
5. Click Save.