Skip to Content
0

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

Apr 25, 2017 at 04:14 AM

310

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Apr 25, 2017 at 06:14 AM
0

"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

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

Hi Vadim,

Thanks for correcting me and sharing document.

I have written below code in my specificsheet but it did not work.

Function AFTER_CONTEXTCHANGE()

Dim epmobj As New FPMXLClient.EPMAddInAutomation

epmobj.RefreshActiveReport

End Function

Could you please confirm if the above is correct or not?

Thanks,

Vishu

0

"I have written below code in my specificsheet but it did not work." -incorrect!

You have to create new code module and put your code in this new module!

0