BIP has limitation of 100000 active cells for an EXCEL template

spkarkha-Oracle

In Oracle_Analytics_Server_Linux_5.9.0 for BIP Report, the maximum number of active cells is Excel Template is only 100000.

There are many reporting requirements for example SAMA BASEL 4(Regulatory report) template where the number of cells is more than this limit.

Hence this limitation must be removed, or at least a patch must provide to the project where this issue is been faced.

Rahul Katiyar-Oracle

This issue can be resolved by updating xdo.cfg at below path and added <property name="excel-template-max-fields">

Path: /Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig/bipublisher/Admin/Configuration

Here is an example:

[oracle@vmoap2024 Configuration ]$ cat xdo.cfg

<config version="1.0.0" xmlns=http://xmlns.oracle.com/oxp/config/>

<properties>

       <property name="webservice-optimization">true</property>

       <property name="html-use-svg">false</property>

       <property name="html-use-data-uri">false</property>

       <property name="server.WS_REPORT_OUTPUT_PATH_ENABLED">true</property>

       <property name="xdk-secure-io-mode">true</property>

       <property name="excel-template-max-fields">2000000</property></properties>

       </config>

Restart all the services and retest the issue.

Regards

Rahul K

RVohra

Thanks, Rahul, for this information. Is it possible to share the official oracle documentation or blogs where above steps are documented? Appreciate your help!