BPF Workspace context overrides EPM report Context

[former_member221145]

Hi Experts,

I am encountering a strange issue, where I am unable to refresh the report for a different context member. For example I have access to two entities A and B and the workspace context in BPF shows A.

Scenario1

1) Open the BPF Activity(with workspace context set to entity A).

2) Report opens with the entity selection as A.

3) When I try to change the entity A to B (in Epmselectmember) and refresh, the report rollsback to entity selection A and refreshes for Entity A.

Scenario 2

1) Open the BPF Activity(with workspace context set to entity A).

2) Change the context to B in workspace context. (refer to screenshot1)

3) Open the report, refresh the report refreshes the data for entity B. (means i have access to the member B as well)

4) Again if I try to change from B to A in the report , it is defaulted again to entity B.

So what ever the context is in the workspace context that is overriden on the report context and doesn't allow to change. Context defined in hyperlinks

Thanks,
Rohit

[former_member221145]

Hi Experts,

Could someone please give some inputs on this one?

Thanks,
Rohit

[Soumendu]

Dear,

This is how it should work. If there is a need to change the value of a dimension then context should not be set in BPF.

It looks like your design is wrong here.

While designing BPF, you need to identify the context dimensions and driving dimensions. These are the dimensions, which will be set from the BPF & Activity. Rest of the dimensions can be changed by user through EPM Context.

Hope this helps!

Regards,
Soumendu

[Former Member]

In addition to Dutta's comment, if your BPF design can't change for whatever reason, you can easily write a small vba/macro where you can still override the locked context member, e.g. using the EPM API called "SetContextOptions".