OBIEE Download Data more than 65k and to view all the records at once.

I have raised an Oracle Service Request for one of the user's request to download data more than 65,000 rows. They haven't provided me with solution but discouraged from downloading data more than 65,000 rows. But after looking around online, I have tried this link and it worked.
http://obiee101.blogspot.com/2010/01/obiee-resultrowlimit.html
The default max result rows is 65,000 by adding a value more than the default value would help us download data more than 65k rows but what would be the correct value and what is the purpose of OBIEE needs to be better answered before we make that change.
I have made this change on my local instanceconfig.xml for users who require data for analysis because if we make this change on the server and if there are numerous users downloading data at will, the overall performance would have severe implications.
200000

There has been one more strange requirement by the users to view all the rows at once in table view. In Table view we have a radio button to display all the rows at once but we encountered performance issues and the reasons could be many.
1) The number of fields on the face of the report.
2) The aggregated measures used.
3) The resultant rows.
4) The CPU Usage and memory issues ( IE when downloading would use 70% of the CPU Memory)
Service Request was raised and The Oracle response was OBIEE Reporting tool is for analytical reporting and What is the business requirement to see all the records?
OBIEE is not for general purpose reporting. Though the option is there for all records. It is always recommended to develop reports using various other features (Hierarchy, parent/child reports, drill down, Navigate, filters, etc...)
Depending on the data, performance issues are expected.

If anybody has ways to improve performance or faced similar issue before and were able to resolve could respond to this post.

Cheers
Vishal