Skip to Content
0
Sep 25, 2013 at 05:39 PM

Results from another query limited to 1000 rows

1928 Views

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 11.2.0.3.0.

I am curious where the bottleneck is on this situation.

Thanks,

Noel

Attachments

pastedImage_4.png (56.7 kB)
pastedImage_5.png (10.7 kB)
pastedImage_7.png (30.6 kB)