Skip to Content
avatar image
Former Member

How to refresh specific report/sheet after changing Context member using VBA?

Hi Everyone,

I have requirement to refresh automatically specific report/sheet after changing Context members using VBA?

This is my report and used EPMContextMember for User selection. So when user changes time then report should get refresh automatically using VBA - AFTER_CHANGECONTEXT?

NOTE : I don't want to use option " Automatic refresh on Context change" in User Options as if i select this option then all the worksheet/all the reports will get refresh.

I basically looking for refresh only report only specific report/sheet

capture.jpg (35.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 25, 2017 at 06:14 AM

    "So when user changes time then report should get refresh automatically using VBA - AFTER_CHANGECONTEXT?"

    The correct name of even function is AFTER_CONTEXTCHANGE

    Please read EPM help 42.7 Custom VBA Functions (Events)

    https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.28/en-US/f9b8a4b16faf1014878bae8cb0e91070.html

    Add comment
    10|10000 characters needed characters exceeded