Refresh Issue

[Former Member]

Hello All,

We are using =EPMRETRIEVE functionality for some reports, wherein it fails to load the data onto the report. It simply gives =RFR on the places where we have used the formula,referring to refresh the worksheet. While we refresh, the splash screen appears and goes off in a flash, with no retrieval of data from the back-end and I believe it doesn't work at that instance. And also the issue is intermittent and it does not always happen.

We have tried clearing the metadata cache and logged off and logged in to EPM while we face the issue, but still the issue is seen.

System details are as below.

CPMBPC

801

0003

Is there anyway the issue could be avoided, while the issue is seen?

Regards,

Madhav

[akos_beres]

Madhav,

How many of these formulas are on a worksheet? When there are a large number of these formulas, Excel memory issues can cause the formulas not to refresh.

Akos

[Former Member]

Hi Akos,

There are many formulas used in the sheet say about 100 in number.So is there way we can avoid memory issues?
Regards,

Madhav

[former_member186338]

100 is not a huge number! Have you upgraded something?

[akos_beres]

Madhav,

I agree with Vadim ... 100 formulas are not much. I know upgrading BPC on the server side is not a simple task and requires some coordination, the EPM Add-in upgrade should be fairly easy. Before you try upgrading, it might be worth checking out some notes like 2085520.

Hope this helps, sorry for the vague answer but the #RFR errors are not super specific either and can be caused by a host of things.

Akos

[Former Member]

Hi Vadim,

No we haven't upgraded to anything, due to many constraints.
At this point of time we are atleast looking for a workaround when we face these issues.

Regards,

Madhav

[Former Member]

Hi Akos,

Thank you.We had already checked on this, and it is as recommended. The issue is that , it is intermittent.

Any workarounds when we face this issue, is highly appreciated.

Regards,

Madhav

[former_member186338]

Try to upgrade only EPM - just on some workstation! And perform testing...

[former_member186338]

Hi Madhav,

In general you have to avoid usage of EPMRETRIEVE in the reports... It's alway possible to create report without this function.

About system - SP03 for BPC 801 is very old! Upgrade required.

What is the EPM SP you are using?

Vadim

[Former Member]

Hi Vadim,

Thanks for you reply.

We are on SP15 .NET 3.5 for EPM add-in.

Yes, I am aware that EPMRETRIEVE does have performance issues, but due to some requirements, we are forced to use it.

Regards,

Madhav

[former_member186338]

And EPM SP15 is also old, upgrade required!

[Former Member]

I've experienced refresh issues using EPMRetrieve in conjunction with EPM report builder.  For me the issue was quickly resolved with a second refresh.  Can you verify that you are referencing every dimension in your formula (even though it is not required)?  A screenshot would be very helpful!

[Former Member]

Hi DiAn,

I have tried refreshing consequently, but it doesn't update. All we can observe is a splash of refresh screen for a moment and it does go off immediately.

Regards,

Madhav