When EPM context changes Automatic refresh is not working

[Former Member]

Hi All,

In BPF activity instance when we open the same report link for two different profit centres .The report will opens twice with two different profit centres and user doesn't want it like that,

So I have changed the report format from .XLTM to .XLSM then the issue was solved.

By selecting a first profit centre the report will open and refreshing as expected also the second profit centre is overrides the existing member on EPM context bar but not refreshing the report.

User option is enable to Automatic refresh on context changes but not use full.

Please suggest if anyone knows.

Many thanks,

Satish

[former_member186338]

"but not use full" - what do you mean?

[Former Member]

When I switch manually on EPM context pane the reports refreshing but through BPF link the context member is changing but not refreshing the report

Many thanks,

Satish

[Former Member]

Hi Satish,

Since it is user option ask your user to set  user option "Automatic refresh on context change" or use VBA.

If you set that option then it has to work.

Function AFTER_CONTEXTCHANGE()

End Function

Hope this will solve your problem.

[Former Member]

Thanks for your replay

As I was using user option "Automatic refresh on context change" and I've tried VBA as AFTER_CONTEXTCHANGE() but still not solved

Regards,

Satish

[Former Member]

Hi,

Please go to BPF and again select updated template once again. After that also if you are facing same issue please share  some screenshot what you have done.

[Former Member]

Created a template:

Selecting two members

Hyperlink with server root folder root report

Instance created for Jul-16

Selected first member

EPM context updated and report refreshed as expected

Selected Second member

EPM context pane updated but report has not refreshed still showing the previous

one, If I refresh manually report appears to what is in the context pane

[Former Member]

Hi Satish,

I thought you were taking about withing template template if you change the context then it i not refreshing template but i was wrong. For your case you can use "Refresh Data in the Whole file when opening it" option from sheet option. No need of VBA also. It will refresh while template opening so you will get current context member.

Hope  this will resolve your problem.

[Former Member]

Tried different ways like Refresh Data in the Whole file when opening it, Automatic refresh on context change and using VBA still not working

Thanks,

Satish