Report Protection in BPC 10

[Former Member]

Hi,

I have built a epm report, in which I am using entity in the row and time and currency in the column axis. In the row axis, I have put only nodes (neither children nor base members). Report is working fine. But when user double click on the rows, entity nodes get expanded, which in turn ruin the some fixed formatting.

In order to avoid this issue, I went to EPM formatting sheet and locked the row headers Only (right click on the cell and select "Lock Selected Cell" and then applied EPM sheet protection. But it is not working. Previously I created such type of reports, when I applied lock through EPM formatting sheet and clicked on the row headers, it used to throw a pop screen stating that "sheet is protected".

seeking suggestion on it. as I don't want to user to expand the entity nodes in row. however I tried some other options such "Enable Double Click" or "Exclude or Keep", these options are not quite useful in my case.

help is appreciated.

Regards,

[former_member186338]

Hi David,

If you use EPM protection then after parent double click you will have expansion - EPM protection is disabled on the expansion.

Why not to disable "Enable Double Click"?

Vadim

[Former Member]

Hi Vadim,

Thanks. Tried this option. But I have Headers on the top of the report (As Page Axis or dimensions other than which I have included in row axis and column axis), using EPMContextMember() function for users to double click on the cell and select the member.

If I uncheck "Enable Double Click", I am not able to select member from that headers too as double click is disabled.

Regards,

[former_member186338]

Then - no luck

If you can use VBA then some solution can be proposed...

By the way, the entity list is fixed? How many?

Vadim