Refresh error on Webi
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.
Victor Gabriel Saiz Castillo replied
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: