Skip to Content
0
Aug 30, 2023 at 01:28 PM

Programmatically Suppress Zeros in SAP Analytics Cloud via Toggle Switch

64 Views Last edit Aug 30, 2023 at 01:29 PM 2 rev

SAP Analytics Cloud comes with a built-in feature to checkbox that allows you to hide/unhide "Zero" values.

You also have the ability to hide/unhide "Null" values as well as to include "Unbooked" members from a table.

We have a requirement to create a switch that programmatically toggles between Hiding/Unhiding Zero values from the rows of a table. SAC designer tools comes with a such a widget (switch) but it requires scripting.

We cannot use APIs since the one available for this requires SAP BW as a source.


This solution will require scripting the code for the toggle switch to hide/unhide Zero values.

Assistance with this code would be highly appreciated.

Best to All