#RFRs on all cells in Report

[Former Member]

Recently, a few of users have reported an issue where they receive a #RFR for all cells which are retrieved from the database.

This is no longer a sporadic issue.

We are using BPC 5.1 SP3 and our database is on SQL 2000.

Any and all assistance is greatly appreciated!

Thank you in advance!

[Former Member · Accepted solution]

I have seen this when I processed dimensions in which there was a structure changed in the parenth1 without checking the full process checkbox. Was solved after processing the dimension with full process or after modify application.

-joost

[Former Member · Accepted solution]

Hello Joost,

I THINK that may have been the case here.

I did a full reprocess of all the dimensions (because I didn't know which dimension had hierarchical changes) and the cubes, and it seems to have fixed the issue.

Thank you!!!

Garvi

[former_member599120]

HI Garvi Koushik,

The symbol "#RFR" always appears when you using "EVGTS()" OR "EVCOM()" function and you don't expand that. Perhaps, Are you using that function ?

Regards,

Wandi

[Former Member]

Hello Wandi,

The report does not have EVGTS nor EVGET...but it does have EVSND.

The #RFRs appear even after expanding and refreshing the workbook.