Oracle Fusion Middleware: Increasing Numbers Of Row To Display/Export to Excel From Analysis in OBIEE 11g - Excel'e Export Alınırken Görüntülenen Satır Sayısının Arttırılması

When we try to export one report that we had in OBIEE, we encountered with a problem which said that we were exceeding the maximum limit of row numbers that could be seen in an Excel Report. Problem looked like the picture below:

The error code was EY692ZW9 (Maximum total number of cells exceeded. (Limit 50000)).

Therefore we looked for the ways to solve this problem. To overcome this difficulty we had to change some parameters in our instanceconfig.xml which was found in the following path:
C:\oracle\OracleBusinessIntelligence\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\

After we have reached our destination file, we then changed the tab with the following lines.

 

  
     

75

25000

false
5000
2500
500000
5000
1920000



75

25000
2500
500000
5000
1920000




Briefly, we added the following parameters to both the tab and the pivot .

2500
500000
5000
1920000

In the end we able to extract all the rows we need in our report which needed 28000 lines instead of just 8000.

References:
1-http://oraclebisolutions.blogspot.com.tr/2013/01/increase-number-of-rows-to.html
2-https://community.oracle.com/thread/2341945?tstart=0
3-https://community.oracle.com/thread/2391197?tstart=0
4-http://shivabizint.wordpress.com/2011/08/26/export-more-than-6500-obiee-11g-records-to-excel/
5-https://community.oracle.com/thread/2473815?tstart=0
6-http://ruchi-obiee.blogspot.in/2012/05/to-limit-number-of-rows-in-pivot-table_07.html
7-http://docs.oracle.com/cd/E25178_01/bi.1111/e10541/answersconfigset.htm#CIHJDHGI