EPMContextMember check not working when openning workbook

[mauriciobrandon]

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).

[jrg_finster3]

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

Regards

Jörg

[mauriciobrandon]

Thank you, Jörg and Vadim.

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

Regards,

Maurício.

[former_member186338]

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?