Set Advanced Cube Properties

If the current cube is a block storage cube, then you can select whether to aggregate missing values, create blocks on equations, or enable two-pass calculation in Advanced Cube Properties.

• 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. Navigate to the Settings tab.

   In the Redwood Interface:

   1. On the Applications page, open the application and then open the database (cube).
   2. Click Customization in the left hand panel.

   In the Classic Web Interface:

   1. On the Applications page, expand the application.
   2. From the Actions menu, to the right of the cube name, click Inspect.
2. Click the Settings tab.
3. Click Calculation.
4. Select the options that you want.
5. Click Save.