RE: BO XI 3.1 SP6
BusinessObjects XI3.1 is a reporting tool – it it not an extract tool and is not designed to extract data.
The “limit” is based on your database, network, server sizing, user load and client you are opening it from.
Sure you can do this but it won’t perform particularly efficiently and it would depend on what tool you are using. A desktop tool has fewer imposed timeouts than a web-based tool.
If you are talking about Data Services then that is an extract tool and would cope with this much better. That said you are still governed by many of the constraints above but it is designed to extract data.
If you are trying to extract data using BusinessObjects Web Intelligence or any other reporting tool, don’t. It’s not designed for that.