Macro to hide key figure in Data View

[emani_raghavendra]

Hello Experts

We have a requirement to hide one key figure via Macro . This macro will be default macor. So whenever, user logs into planning book, it will hide the key figure. i have user Row_Visible functionality in the Macro for this. But i see that Key Fiigure is till visible. ANy idea why so ? Is Row_Visible = 0 makes a particular row invible or is this used for some other functionality ?

Request your suggestion here

[alok_jaiswal]

Hi Raghavendra,

Yes ROW_VISIBLE function is used to set visibility of row. If (1), row is visible and for (0) invisible. Please check in the attributes of the row or cell, set Scope of change to attributes.

Also besides this there are couple other options to make key figure invisible -

1. In the interactive planning book,Right click on the key-figure to be hidden (selected rows -> Hide). Save the planning book. Key figure will be hidden.

2. In Interactive planning book, select user settings. There is a tab for “Hide Key Figures”. Select the box for Key figure we want to hide. Save and backout.

Hope it helps.

Regards,

Alok