Maximium number of rows

[Nitibob]

Hi all,

I was wondering if anyone has had any experience of Business Objects crashing due to number of rows fetched back.

I'm using BO Ver 4.1.3. The query is hitting one table. This table has 3.5 million rows - BO crashes out at about 1.8 million mark.

Is this a bug and can anyone offer any suggestions?

 

[skrandel]

Are you trying to return all those rows to the report?

If so, why? BO can't handle that much data in a report.

If you are trying to go through that table so that you can summarize it, then you should be using measures that are aggregating in the select statement so that your query is generating SUMs and GROUP BYs.

Millions, even billions, of rows is just fine. But you can't bring it all back to the report. Let your database engine do some work. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com