How to increase export limitation in OBIEE11g.

By default OBIEE will export 2500 rows.
Some times our client requirement will be to export more than 2500 rows.
To increase export limitation follow below steps and let me know if anybody facing issues while doing below steps.
 

Here we need to change insanceconfig.xml file.

Go to below location and take a backup.

Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Instanceconfig.xml

Open Instanceconfig.xml file .

And go to Views section.

There we will see pivot and table sub sections.

Open in notepad and add below XML code to two sub-sections.

---------------------------------------------------------------------------------------------------------------------

<DefaultRowsDisplayedInDownload>500000</DefaultRowsDisplayedInDownload>

<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>

<MaxVisiblePages>2500</MaxVisiblePages>

<MaxVisibleRows>500000</MaxVisibleRows>

<MaxVisibleSections>5000</MaxVisibleSections>

<MaxCells>500000</MaxCells>

And save it.

Now re-open the xml file and it should be like below screen shot.

Replace modified instanceconfigfile.xml file in original location.( Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Instanceconfig.xml)

Now go to Enterprise Management (EM) and follow below steps.

Step 1:  click on Lock and Edit Configuration.

Step 2: Go to Capacity Management, and click on Performance tab.

Step 3: change value for Maximum Number of Rows to Download to 500000. (It should be the value which we given in XML)

Step 4: Click on apply button.

Step 5: Click on Activate changes.

Step 6: Restart the services.