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.
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
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.
No comments:
Post a Comment