Skip to Content

EPMContextMember check not working when openning workbook

Mar 02, 2017 at 01:43 AM


avatar image

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

Thank you, Jörg and Vadim.

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