Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Smartview drill down Threshold Issue — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smartview drill down Threshold Issue

Received Response
28
Views
5
Comments
edited Mar 4, 2020 4:39AM in Planning 5 comments

Content

Hi all,

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
Error Threshold:nullVALUE

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!