Hi,

You must change some data in instanceconfig.xml on your server.

There are many tutorial about this, for example: https://shivabizint.wordpress.com/2011/08/26/export-more-than-6500-obiee-11g-records-to-excel/ or OBIEE Solutions: How to Increase row limit to Display/Export to Excel from Analysis

Mahesh...marking my reply as helpful but not saying anything isn't really and actually helpful is it? :-D

Ok but then why do you go through the browser interface?

1.) Every database can send stuff directly from the database to a file sysstem, a mail recipient, etc etc

2.) You can access the OBI server throguh ODBC if you need the semantic model to kick in so that's already a lot less trafic than what you're doing but still more than a pure DB level

3.) Going DB -> network -> OBIS -> OBIPS -> network -> browser -> desktop is the most inefficient thing you can possibly do

4.) There's BIP who can read from just about anywhere and send to just about anywhere without the - again useless and non-value-adding - step of the front-end

5.) Oracle even wrote a paper on this: https://support.oracle.com/rs?type=doc&id=1558070.1

6.) This question is asked at least once a week in this forum and we always say the same: When you have to move tens of thousands of rows to the front-end then there's probably something going extremely wrong

And last but not least: 7.) I get that your client asks you this but if you look at the points above you'll see that this is really ridiculous in terms of optimizataion, utilization of resources etc.