Improving the Performance for Exporting Large Analysis Reports to Excel

For organizations that export analysis reports with large amounts of data to Microsoft Excel format, you can make the following configuration changes:

1. In a command prompt, navigate to root\myMicros\Oracle\Middleware\instances\ORCLRNA\bin, and then enter opmnctl stopall.
2. In the Microsoft Windows Services Manager, stop all beasvc bifoundation_domain_bi_serverX, and then stop beascv bifoundation_domain_AdminServer.
3. In the file explorer, navigate to root\myMicros\Oracle\Middleware\instances\ORCLRNA\OracleBIJavaHostComponent\coreapplication_obijh1.
   1. Open config.xml in a text editor and configure the XMLP tag:

      <XMLP>
          <InputStreamLimitInKB>0</InputStreamLimitInKB>
          <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>
      </XMLP>

   2. Open xdo.cfg and add the following in the properties tag:

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

4. In the Microsoft Windows Services Manager, start beascv bifoundation_domain_AdminServer, and then start all beasvc bifoundation_domain_bi_serverX.
5. Log in to the Oracle WebLogic Administration Console, click Deployments, and then verify or wait for all services to become Active.
6. In a command prompt, navigate to root\myMicros\Oracle\Middleware\instances\ORCLRNA\bin, and then enter opmnctl startall.