SmartView - Performance Degradation when Suppression of Missing and Zeroes Enabled
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.
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):