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>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>