I have occasionally used the "Results from another query" as an operand in a query filter.
Unfortunately, if my base query has too many values I get this error.
But how many is "too many"? So I did a little testing and set my "Max rows retrieved" in the Query Properties to a variety of numbers and got to the point where it works for 1,000, but not 1,001.
So is this some sort of global BI limitation? Is it limited at the universe somehow? Or maybe the underlying database may be the issue? For this example I am hitting the database is Oracle 11g Enterprise Edition Release 126.96.36.199.0.
I am curious where the bottleneck is on this situation.