Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
SmartView - Performance Degradation when Suppression of Missing and Zeroes Enabled — 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 - Performance Degradation when Suppression of Missing and Zeroes Enabled

Question
2
Views
0
Comments

Summary:

When we run big reports out of our ASO app we see performance degradations when Suppression of MIssing and Zeroes is enabled in SmartView. The suppression triggers and MDX query which slow down the whole end to end retrieve. This was not happening with the on-premise platform the the suppression was truly used to improve performances.

Content (required):

this happens with Custom Planning as well as FreeForm apps. the ASO is fully optmized with hierarchies setup and we use complex dynamic calc members with formulas in the retrieve.

Version (include the version you are using, if applicable):

EPBCS. 22.03

SmartView 21.200

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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