Skip to Content
author's profile photo Former Member
Former Member

Force a BEx Query to always read from from database

We have a WebI report that uses two BEx queries. One of these BEx queries uses a virtual cube that reads from a simple file. The idea is that the report user can adjust the value in this simple file to do what if type reporting. So we would like for the user to be able to run the WebI report, then change values in the file, then rerun the WebI report. But right now when they refresh the WebI report after changing the values the query is not returning the new value from the file.

Example: I have a value in the file of 100 percent for work center A. I run the WebI report and it picks up 100 percent for work center A. I changed the value for Work Center A to 90 percent and refresh the WebI report that is still open. But the report is still showing 100 percent. If I close the report and rerun it then it picks up the 90 percent. But I'd like to get it to pick up the change when the report user refreshes the report.

Any Ideas? I've tried some property settings in RSRT, but no luck yet.

Add comment
10|10000 characters needed characters exceeded

0 Answers