OBIEE 11g Table View Limts

Issue today were in OBIEE 11g the number of rows brought back initially in a table view were low (25) and the user wanted the 10g (view all rows) functionality "unlike the OOTB 11g settings where it only showed up to 500" . So off to Oracle docs I was to find the solution.I have found the following setting that need to be made depending on what you are wanting to set the behavior to (be careful of some of these setting and do not set them too high or it could cause issues on BI server as well as Data Warehouse. Cahnges made to your instanceconfig.xml file located at:

<YourMiddlewarehome>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>5000</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2000</MaxVisiblePages>
<MaxVisibleRows>100000</MaxVisibleRows>
<MaxVisibleSections>2500</MaxVisibleSections>
</Pivot>
<Table>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>
</Table>
</Views>
Restart Presentation Server within EM, verify via export and table run on dashboard.

*Any setting preceded with  "<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->" will need to be set in EM as if you change it in the instanceconfig.xml will get overridden as soon as the presentation server is restarted.


**Note the new elements added are the following to both <Pivot> and <Table>; depending on which you want to modify.