OBIEE 11g: How To Improve the Functionality of Exporting Data from Analyses, Dashboards, and other Oracle BI Presentation Catalog Objects into Microsoft Excel with OBIEE 11.1.1.7.131017

I have come across an oracle technical note on how to improve the functionality in general and performance in particular of exporting data into Microsoft Excel from OBIEE 11g.

This blog is an attempt to share content from technical document to wider audience.  

Editing Settings in OracleBIJavahostComponent

To improve the functionality of exporting data from analyses, dashboards, and other Oracle BI Presentation Catalog objects into Microsoft Excel, edit settings in OracleBIJavahostComponent by performing the following steps to complete the Suite Bundle Patch installation:

Navigate to the /instances/instance1/config/OracleBIJavaHostComponent folder.

In the config.xml file, configure the XMLP tab for large data as follows

<XMLP><InputStreamLimitInKB>0</InputStreamLimitInKB>

Setting InputStreamLimitInKB governor value to zero (0), which is unlimited, should only be used for testing. Set the value to something reasonable that works with your large data sets.  The default is 4096 (4MB), but you may need to increase it to 8192 (8MB), 16384 (16MB), 32768 (32MB), etc. (1024 * X).  

<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing></XMLP>

In the xdo.cfg file, change the setting for xlsx-keep-values-in-same-column to True.

Note: if the entry does not exist, then you can add it in the following format: 

<property name="xlsx-keep-values-in-same-column">true</property>

Restart Web Logic Server, Managed Server and OBIEE Services

                          

UNIX

WebLogic Administration Server

Navigate prod_mwhome/user_projects/domains/<domain_name>/bin

./startWebLogic.sh

Managed Server

Navigate prod_mwhome/user_projects/domains/<domain_name>/bin and enter the following at the command prompt:

./startManagedWebLogic.sh bi_server1

BI Services

Navigate to prod_mwhome/instances/<instance>/bin and enter the following at the command prompt:

./opmnctl startall

Windows

WebLogic Administration Server

Navigate prod_mwhome\user_projects\domains\<domain_name>\bin and enter the following at the command prompt:

startWebLogic.cmd –start

Managed Server

Navigate to prod_mwhome\user_projects\domains\<domain_name>\bin and enter the following at the command prompt:

startManagedWebLogic.cmd bi_server1

BI Services

Navigate to prod_mwhome\instances\<instance>\bin and enter the following at the command prompt:

opmnctl startall

I hope you find this information which I have shared from Oracle Support is useful.