You can use Suppress Missing Blocks to improve performance when rows or columns contain sparse dimensions. Suppress Missing Blocks allows placement of 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, 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.
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.