"Result from another query" in query filter is not getting updated

[former_member626942]

After stepping up from SAP BusinessObjects Business Intelligence 4.2 Support Pack 5 to Support Pack 6 and also to Support Pack 7, we encounter a problem in scheduled WebI Reports with a data provider filter using "Result from another query": The result from another query in the query filter is not getting updated when the report runs automatically next time.

Did anybody else experience a problem like this? How can it be solved?

Regards, Michael

[former_member626942 · Accepted solution]

Actually, it seems to be the other way round: We have the parallel query processing disabled when the problem occurs. When we enable parallel query processing, the "Result from another query" is updated in the filter.

Also, the order of the queries play a role: When we put the query containing the filter on "Result from another query" last, the value is updated in the filter as well.

[amitrathi239]

It seems a bug. Can you try with disable the parallel queries run option and see? maybe because of parallel queries you are getting wrong results.

2360251 - How to disable the Parallel Queries functionality in BI 4.2 SP03 or higher