Zero or null suppression

[former_member875256]

Can anyone tell me how to delete null rows or columns in sap sac by scripting on button.

[Sricharan]

Hi!

We implemented a solution in a recent similar use case where the client wanted switch between row-wise null suppression ON/OFF on a table in SAC story. We achieved this by creating 2 identical tables (one with null suppression ON and one with null suppression OFF), overlapped them, and used scripting to show the required table on switch (switch as an element added and script added to onChange of switch position) ON/OFF. 

This may not be the best solution overall but since Nullsuppression as a function is not yet available (unlike zerosuppression) from SAC, this method is an easy work around to achieve this.

Best regards,
S. Sricharan.

[N1kh1l]

nikita08

nikita08I am not sure what you mean by deleting null rows or columns in SAC. If you meant to not show null values in SAC table widget then you can enable the null suppression for both rows and column in designer section of the widget

If you meant deleting it from model then, Null means that there is no value and it cannot be deleted from data base

Hope this helps !!

Nikhil

[former_member875256]

Hey Nikhil Thanks for your response, I want to add a button on my story, and that button will do that zero suppression and null suppression So, I need that script for zero suppression and null suppression on that button so that null rows/columns will get deleted