Saturday, January 12, 2013

Increase number of rows to Display/Export to Excel from Analysis


By default only 500 rows are shown. Even though “Maximum Number of Rows to Download to Excel” is set to 2500 rows by default, only 500 rows can be exported to Excel. Solution for this is to modify instanceconfig.xml , which is located at \instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1\
Search for  <Views>, add the following between before </Pivot> and </Table>.
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

Save the file, and then restart the Presentation Server from FMW Control EM. Test creating a request and export it to excel from both Pivot and Table views.