Skip to Content
Former Member
May 15, 2013 at 10:11 AM

Update Context based on selected member



I am using BPC 10 MS (SP10) and the epm add-in (SP14). I had the same issues on a BPC SP09 and epm add-in SP12 patch 4)

I am trying to update the context of a dimension based on the selection of another dimension.

For example, If in my context, I select "Entity A" in the Entity dimension, I want to have "Project 1" selected in the Project dimension.

I tried to use the

- BEFORE_CONTEXTCHANGE : does not work because the Entity is still the "old" one, so I cannot set the new project

- AFTER_CONTEXTCHANGE: context updated with VBA does not display in the Context. This is probably because the context change has alredy happened.

What is interesting, is that if I have an Excel formula with "EPMContextMember", it shows the new value (but the Context on the top shows still the old value).

Does anybody know if we can call the context change event from VBA or another way to get the context refreshed properly.

I also tried to perform a refresh in the AFTER_CONTEXTCHANGE, but it does not work consitently (sometimes is gets updated, sometimes not).