Evgts Input Template Retrieving no data and shows #RFR Errors

[Former Member]

Hi Experts,

Need opinions regarding a weird issue I am facing in BPC 5.1 version.

Details of the error :

We have the Entity Hierarchy in Rows and Accounts in Col. The Input template refreshes and brings on the existing values for the Topmost (Lowest Level) member selection in the Entity.Similar is true when the Entity member is lowest in the Hierarchy.

The template shows wierd #RFR error when selection is done for one particular Member in the Entity hierarchy.

This template is only showing #RFR for this member and refreshes for all other members.

The Report uses Basic function EVGTS to retrieve the Data and EVSND to send.

Any help would be greatly appreciated.

Regards

Raghav

[Former Member · Accepted solution]

Hi Raghav,

We also faced similar issue.

The test result tells us it is due to number of columns with EVGTS. It is not due to any particular EVGTS formula in any column.

You can try out removing EVGTS formulas in the report and add one by one and try out.

Does anyone know why number of EVGTS formulas with combination of number of columns resulting into #RFR error!

Thanks,

Rajesh

[Former Member]

Thanks Rajesh,

I will try this option, if it can do some trick.

Regards

Raghav

[Former Member]

Hi Raghav,

One of the workarounds found is to switch one of the members, i.e.: TIME from 2010.JAN to 2010.FEB and vice-versa, using the Current View and then refresh/expand the report again. Through this method you should be able to see the data, however this might not be applicable for you. In this case, you would have to test to see if it works.

Hope this helps!

[Former Member]

Robert, the Entity expands fine when done with the Dynamic template. So high chances that the template is jacked up. In that case it is weird as this same template expands for other Entity Members.

Do we have an option of putting on a trace or log as in the case of Evdre to debug the send and retrieve process. Just to check out if something is messed up while functions from template query Database.

[Former Member]

You are right Robert, we can use the Evdre Template but this report was developed when the members in the Entity dimensions were less. It is now that the member count has increased.

We are for sure migrate it to the EVdre version.

I have not checked expansion after removal of the filters, will check it and let you know.

It is not one of SAP Dynamic templates but a customized one.

Regards

Raghav

[Former Member]

Raghav,

To rule out a problem with the Entity, try opening an Any by Any report with the Entity in quesiton, no filters. Before you do an Expand All, make sure you change the WorkBook Options to 20,000. If that works, then it is likely a problem with the report.

Hope this helps

[Former Member]

Hi Robert,

This Entity is Parent with more than 9000 Child members, template expands for ~580 members due to the filters. I Tried expanding after setting workbook options for row to maximum, still the error prevails.

Regards

Raghav

[Former Member]

Raghav,

If you take the filters off and set the row expansion to 20,000 in Workbook Options, does it still blow up? Additionally, why are trying to use an EVGTS report with so many members? EVDRE would be much faster.

When you get this error, is it on a custom report or on one of the template reports?

Thanks

[Former Member]

Guys, appreciate your thoughts;

Robert,

I tried for the same selections, and retrieved the data succesfully using an Evdre Template.

Vishal,

The same schedule is retrieving the data for other Entity selections.

Regards

Raghav

[Former Member]

Raghav,

How many entities are you bringing in? Is this a parent level entity or a base member? If you are bringing in more than 1,000 rows, you may need to eTools-> Workbook Options and change the limit to either 10,000 or 20,000.

If it is just the one enitty, on the left in the green grid, does it show Entity::EntityID?

[Former Member]

Raghav--

If the earlier suggestion did not work..

try right clicking on the cell and "format cell"..change it to "general"/"text"...hit F2..

this shld fix the issue.

hope this helps..

Vishal.

[Former Member]

Raghav,

By chance is the Entity ID in question used in another dimenison? For example, Account 100 and Entity 100 ?