Worksheet Refresh - EPM vs VBA

[former_member279641]

Dear Community,

Is there any difference in behaviour, between the following:?

1. The 'Refresh Workbook' option via the EPM Ribbon Bar.
2. The following line of VBA code - Application.Run "EPMExecuteAPI", "RefreshActiveWorkbook"

Some of our users have claimed that their reports sometimes don't refresh properly when using method #1, however always refresh properly when using a button within the report that executes the line of code in method #2.

The systems integrator asserts that the two are exactly the same, and that the button was placed on the forms for ease of use. A number of users aren't convinced however.

Kind Regards,

Simon.

[former_member186338 · Accepted solution]

Hi Simon,

Please read my answer here:

Vadim

P.S. It's absolutely the same as pressing button on the EPM ribbon

[former_member279641 · Accepted solution]

Many thanks Vadim, it's great to have the second confirmation.

[former_member279641 · Accepted solution]

Hi Vadim,

I went back to our BPC users to find out what evidence they had to show that the two methods of refreshing didn't produce consistent results.

We have a report that fetches information from 2 different models. The cells in this report that contain 'EPMRetieveData' functions will sometimes display '#RFR' after using the EPM refresh method.

When using the Refresh button linked to the VBA code, these cells will always populate as expected, first time. Following use of the button, the EPM Refresh will then work consistently also. One of our BPC users has undertaken some extensive testing to prove this to be the case.

Any ideas why this may be?

Kind Regards,

Simon.

[former_member186338 · Accepted solution]

Hi Simon,

You are describing something very generic...

"cells in this report that contain 'EPMRetieveData' functions will sometimes display '#RFR' after using the EPM refresh method"

Also, VBA code may contain some additional lines called indirectly (for example using BEFORE_REFRESH event with flags set in the macro linked to the custom Refresh button...)

Try to create simple and reproducible test case and provide the details.

Vadim

[AlpAltinturk · Accepted solution]

vadim.kalinin the link in your answer is gone.. deleted maybe?

[former_member186338 · Accepted solution]

alp.altinturk

For sure I don't remember the link provided 4 years ago!

Please ask a new question and provide full info about your issue!

[AlpAltinturk · Accepted solution]

vadim.kalinin Did I ask you to provide anything in a disrespectful way to deserve such a response? Of course it has been 4 years since your reply.

My comment was to understand if the response has been edited by you or got deleted somehow. What a disproportionate response.

[former_member186338 · Accepted solution]

alp.altinturk

I have no idea what happened with the link in my answer. For sure I haven't deleted it myself... May be it's a result of conversion from old system...

And once again, if you are interested in the subject, it's better to ask new question with full info about your case.