Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Refresh error on Webi

Dear all,

I have problem with refresh error on webi report.

Requirement : If I selects vendor on input control, it should bring respective data

I have a KPI called OTD % in webi report which has calculation on Backed (BW).

when i select the region on prompt it will bring the vendors list those comes under selected region.

And i have set input control for vendor. whenever i select region on prompt, the default selection for input control will be "All values" and data looks fine. but when i select any vendor on input control, i face some error(see second screen shot). And when i refresh the report again it works fine.

So alternative it requires to refresh the report. Has anyone faced this kind of issue?

Is this because the calculation done at backend?

All other kpi's are working fine which has no calculation at backend.

after refresh

Former Member replied

Hello Vijay,

we cannot see the message as the column is not wide enough, but my educated guess is that you get the #TOREFRESH message. If so, you can avoid it by inserting a hidden table with Country Vendor, Vendor OTD and OTD %. Yes, it is because of the DB Delegation of the key figure. More about this topic in this blog post:

All you need to know about #TOREFRESH

Best regards,

Victor

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question