Planning Considerations for Designing Reports Using Suppress Missing Blocks

You can use Suppress Missing Blocks to improve performance when rows or columns contain sparse dimensions. Suppress Missing Blocks allows placing 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, when using this option, you can 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.

Using Suppress Missing Blocks aids the performance of Suppress Missing Data when suppressing a large number of rows, such as 90% or more. The Suppress Missing Blocks setting can degrade performance if few or no rows are suppressed. Also, certain suppressed blocks may ignore Dynamic Calc members.