Obiee CSV Export Limit Change

Issue Description:

When we export a Report in CSV  format in Obiee11g, by default it will export 65,000 rows.

Even if we increase the below parameter in "instanceconfig.xml" it won't work for CSV format .

"<DefaultRowsDisplayedInDownload>200000</DefaultRowsDisplayedInDownload>"


Solution:

We need to add another parameter for CSV separately, it won't be available in config file by default.
This should be a new tag under <Views> <Table> 

<DefaultRowsDisplayedInDownloadCSV>300000</DefaultRowsDisplayedInDownloadCSV>

1) After this change, take backup of existing instanceconfig.xml

Path: $MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

2) opmnctl stopall

3) Replace instanceconfig.xml

4) opmnctl startall

5) Download now beyond 65,000 rows in CSV



Note: 

Do not add this parameter under <Pivot> section, this will not let presentation services up.
Parameter under table section, will also work for Pivot Table download.