Skip to Content
avatar image
Former Member

EPMContextMember check not working when openning workbook

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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?

    Add comment
    10|10000 characters needed characters exceeded

  • 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

    Regards

    Jörg

    Add comment
    10|10000 characters needed 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.

      Regards,

      Maurício.