Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP has limitation of 100000 active cells for an EXCEL template

Submitted
34
Views
1
Comments
spkarkha-Oracle
spkarkha-Oracle Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

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.

Screenshot 2024-12-18 122941.png
Tagged:
6
Up
6 votes

Submitted · Last Updated

Comments

  • Rahul Katiyar-Oracle
    Rahul Katiyar-Oracle Rank 1 - Community Starter

    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