OBIEE 11g – Export/Print to PDF Does Not Include All Rows

We face this issue about export/print of an analysis to pdf format in OBIEE 11g, where it dos 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 which is mentioned in Config File and 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 \instances\instance1\config\OracleBIJavaHostComponent\coreapplication_obijh1\
2. Open config.xml file in an editor and search for  the below lines

         
            <InputStreamLimitInKB>8192</InputStreamLimitInKB>
            <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
        3. The default size is 8 MB (1024*8 = 8192), 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.
For example: you can increased file size to 16 MB like in instance, 

       
                    <InputStreamLimitInKB>16384</InputStreamLimitInKB>
                    <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>

     





Enjoy till next time 🙂
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s