Suppressing Missing Blocks

Note:

The ability to suppress missing blocks is available for Planning users only.

You can suppress missing blocks to improve performance when rows or columns contain sparse dimensions. When you suppress missing blocks, you can place large sparse dimensions in rows, while providing good response time if the density of the query is low. Only blocks with data are retrieved. For example, if you place an employee dimension consisting of thousands of members in rows, and place the entity in the page or POV, then only employees of the selected entity are retrieved.

Suppressing missing blocks aids in suppressing missing data when a large number of rows, such as 90% or more, is suppressed. Suppressing missing blocks can degrade performance, however, if few or no rows are suppressed. Also, certain suppressed blocks may ignore dynamic calculation members.

To suppress missing blocks:

1. Select a grid by clicking in the upper left cell.

2. In Grid Properties, expand Suppression.

3. Scroll down and select Missing Blocks.