Hide dynamically measures

[Ganjos]

Hello,

I am working on a project in SAP Analytics Cloud that includes both budget and actual versions, along with a measure called "expenses." My goal is to create a button that, when clicked, triggers a script to hide any measures where the values are null. How can I achieve this functionality?

Thanks in advance,

Gonçalo

[William_Yu · Accepted solution]

Hi Ganjos, 

  I'm afraid there is no API at the moment can support this. But nevertheless, user still can right click in the table on the dimension -> table functions -> show/hide -> and toggle display on/off zero or null. 

  Please also vote and follow influence item: https://influence.sap.com/sap/ino/#/idea/266685

Best regards, William 

[Ganjos · Accepted solution]

Thank you very much! I implemented the functionality using the right-click option. However, when I create a new version (e.g., 'planning1') and copy between versions, blank measures appear again. Is there a way to solve this issue, or will the API handle it? I’ve noticed that if I disable and then re-enable the 'display on/off for zero or null' toggle, it works, but it's not very user-friendly.

[William_Yu · Accepted solution]

I'm not sure why blank measures are coming back after creating a new version, it should keep original state after version operation.