How to disable EPM Show Pane & Context for all users for a particular templates

[former_member187267]

Hi Experts,

I want to disable EPM Show Pane & Context on reports and input templates for all user for a particular templates in SAP BPC 10.1,

And want to lock the context selection for a user ...

Please let me know how to do ?

Thanks

[former_member186338]

You have to use VBA in the Workbook_open event or AFTER_WORKBOOK_OPEN event function.

SetUserOption with:

ShowReportEditionPane

ShowCurrentViewPane

[former_member187267]

Hi Vadim,

I am using below given code

Option Explicit Dim Command As New EPMAddInOOAutomation Sub Workbook_open() ShowReportEditionPane ShowCurrentViewPane End Sub

Find image

But still user can see context pane ..

Thanks

[former_member186338]

Sorry, but your code is absolutely incorrect! Please spend some time reading EPM help - API section.