Problems with synchronization EPMContextMember in several workbooks

[Former Member]

We have a problem with the EPMContextMember in SAP BPC 10.1 (Netweaver version).

Actually we are using several workbooks at the same time.

A user is using 2 different workbooks. The two workbooks have a parameter called "Budget", which are referenced to the same dimension.

In workbook number 1 the user is preparing the "Budget" of the actual month 'SEP.2015', but sometimes the user has to verify a value of a particular project in the last month Budget... In that case the user opens another workbook (number 2) and change the parameter "Budget" to "AUG.2015". That action changes the value of the Budget parameter in the Context from SEP.2015 to AUG.2015.

When the user returns to the Workbook 1, the value of the parameter "Budget" automatically switches from "SEP.2015" which is the valid value to "AUG.2015"

Is there a way to avoid this behavior?. We need a solution to maintain the parameters with different values, not with the value in the Context.

Our EPM Version is:

10.0 SP 22 . NET4

Build: 9188

[Former Member · Accepted solution]

Hi,

We have already solved the problema, we have made a small macro code, that when performing refresh and record events set me the context of dimension, with this function:

EPMContext.SetContextMember

Thanks for your help

[former_member186338 · Accepted solution]

Strange solution... Why do you need to rely on Context at all?

[Former Member]

Hi Emilio ,

Try use "Page Axis" for each workbook so that it will not depend on Context members.

Aravind

[former_member186338]

Instead of relating on Context you can simply use Excel cell with EPMSelectMember...

Vadim

[Shrikant_Jadhav]

   Hi Emilio,

As far as I know ,this is the standard behavior of BPC.

If the requirement is to see last month budget then its better to add previous month in current budget template.

Shrikant