I have a BW query via BICS into my webi report. I have built variables around my delegated key figures using a =SUM(MY BW DEL KF) and have used those variables in my report. I have three input controls, PLANT, DIVISION, and REGION. When I use my input controls I sometimes (not always) get the #TOREFRESH error message.
When I have searched for answers, a lot of the posts are from around 2012 and mention that this issue will be fixed in a future update to BOBJ and I'm hoping that I'm just missing something here. We are on 4.2 SP 8 Patch 4.
I have created a clone of my vertical table, made it hidden, and added in the fields that are being selected on in the Input Controls but still I'm getting the #TOREFRESH issue. The #TOREFRESH issue doesn't happen when I select on PLANT but it does when I select on Division and Plant at the same time. When I unhid my "cache" table, as I like to call them, the cache table displays the data just fine so webi seems to know what the data is.
I have investigated the IN, ForEach and ForAll functions but all I get are errors when using those.
Any help is appreciated.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.