Skip to Content

EPMContextMember check not working when openning workbook

Mar 02, 2017 at 01:43 AM


avatar image
Former Member

Hello, Experts.

We have an Input Form that has a cell formula validation based on context selection for PERIOD dimension (based on EPMContextMember). Basically, if it is a PERIODNA or another DUMMY member of this dimension, it displays a message informing the user to select a valid value for that dimension. Another cell checks if this message is being displayed to mark a flag to not let refreshing/saving values.

When I save the input form into server with this PERIODNA value and another user opens it automatically with a valid value for this dimension, it remains as if it is selected PERIODNA, as if it is something holding this update. If I save with valid values and the user opens it with PERIODNA, it remains as if it has been openned with valid value.

Is there any way to force this recheck/context selection at VBA macro when the workbook is openned? I know there is a function AFTER_WORKBOOK_OPEN, but I couldn't manage to structure a solution with that.

Versions tested:

EPM SP26, both for Office 2013 32bits (3.5 .NET) and Office 2013 64 bits (4.0 .NET).

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Mar 02, 2017 at 12:15 PM

Sorry, but requirements are not clear, please provide screenshots with detailed test case and VBA code samples!

AFTER_WORKBOOK_OPEN - will execute after workbook is opened :) what is the issue?

10 |10000 characters needed characters left characters exceeded
Jörg Finster Mar 02, 2017 at 01:13 PM

Hi Mauricio,

you are right, the EPMContextMember Needs a refresh first.

But you can check the "refresh on Open" Option. Then it should work.

Go on Options -> Refresh -> Refresh Data in whole File when opening it



Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you, Jörg and Vadim.

We managed to update our EPM versions and write some VBAs to workaround dimension filter filling issues here.