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
"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)
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
"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!