How to switch on/off Unbooked Data with script?

[atillacemyildiz]

Hello everyone,
We prepared a report at SAC. People using the report want to see Unbooked Data by default in this report. However, they want to be able to turn it off and on whenever they want.
For this, we activated the Unbooked Data feature of the relevant dimension in Edit Mode. We asked users to disable Zeros in Tables and Nulls in Tables from active to passive in the Quick Menu in View Mode. However, when they did this, we saw that Unbooked Data was turned off, and when we activated it again, Unbooked Data did not open.
We looked to see if we could turn on/off unbooked data by creating a button for this and writing a script inside it, but we couldn't find it.
If you have a solution suggestion, I would be happy if you share it.

[marinakisel · Accepted solution]

Hello @atillacemyildiz ,I have spent a ton of time looking for this myself, and I can say with sadness and frustration that there is no such API.
You can vote for these Improvement Requests to indicate you interest for this functionality to SAP:
https://influence.sap.com/sap/ino/#idea/266685

https://influence.sap.com/sap/ino/#idea/284289

https://influence.sap.com/sap/ino/#idea/294964

Sorry to bring bad news 😐

[atillacemyildiz · Accepted solution]

Thanks for your reply marinakisel,

So, can we find another solution other than creating another table and keeping one open and the other closed?

[marinakisel · Accepted solution]

Unfortunately I don't have any workarounds.

[marinakisel · Accepted solution]

Unfortunately I don't have any workarounds.

[marinakisel · Accepted solution]

...

[atillacemyildiz · Accepted solution]

Thanks a lot again marinakisel

[marinakisel · Accepted solution]

Sorry, I struggle with Comments here. So...setZeroSuppressionEnabled is useless for any non-BW model. Option with 2 tables seems to be next thing to consider. Luckily my users were merciful enough to agree to do the Hide/Show unbooked values from the table options themselves. I would also very much appreciate if there are any ideas in the Community how to script Show/Hide Unbooked.