In OBIEE11g when you export/print an Analysis to pdf or to powerpoint, it does not export all rows. But if you export to an Excel or HTML, it exports all the rows without any issue. This issue has nothing to do with the number of rows but the file size. The file size is limited to 8MB by default.
Need to change the size limit in one of the configuration files. Follow the below steps to achieve it.
1. Navigate to <BIHome>\instances\instance1\config\OracleBIJavaHostComponent\coreapplication_obijh1\
2. Open config.xml file in an editor and search for the below lines
<XMLP> <InputStreamLimitInKB>8192</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing> </XMLP>
3. The default size is 8 MB, you can increase to the size you want. If you want to set unlimited, then replace 8192 with 0 (zero) but it’s not recommended.
4. Restart BI Services.
I have increased file size to 32 MB in my instance, as shown in below image.
