BPC 10: Hiding columns in the report

[Former Member]

Hi,

I am added Time & Category dimensions to Column Axis and am trying to hide some particular columns (that are not needed). But, as soon as I refresh the report, the hidden columns get displayed.

Is there an option that will help me to keep the hidden rows even after refresh?

Thanks,

Purvesh

[Former Member · Accepted solution]

Hi Purvesh,

Once the report is refreshed click "Exclude" for the EPM menu, they will not appear again when the report is refreshed. But this will basically move the member IDs in exclude list, the column will not be hidden.

To hide specific column you have to use VBA code.

Hope this helps.

Regards,

Kalyan.

Normally hidden columns remain hidden on refresh, not sure why it is getting unhide.

[Former Member · Accepted solution]

Thanks Kalyan,

The issue was with the EPM Add-in. I re-installed (a fresh patch) and it is working as expected now.

The hidden columns remain hidden now during refresh.

Regards,

Purvesh

[anilkumar_kalkivai]

Hi,

EPM->Options->Context Options

You can choose not to display a dimension in the EPM Context bar. To do so,

select the Hide checkbox. The checkbox is available in both the Context Display and Context

Lock tabs.

Regards,

Anil.