Smartview drill down Threshold Issue
We were trying to drill-down a SmartView sheet into the bottom level (Lvl0) in WFP in order to view our staff expenses by an individual employee level (this requires drilling down to bottom level for all the employee/entity/job dimensions). When trying to drill-down at that level, we receive an error message as follows
Unable to load the the form as number of cells before suppression (If Form suppression options are selected) exceeded the threshold.
Criteria: Number of cells before suppression
As a resolution step, we tried enabling Missing Rows and Suppress Missing blocks options in smartview, but we had no luck. Only workaround SR provided us was to split the smartview sheet into few smaller parts and retrieve data.