Wednesday, April 13, 2016

OBIEE 11.1.1.7 - Export to Excel 2007+ Error Shell format error

OBIEE 11.1.1.7 - Export to Excel 2007+ Error Shell format error

To Resove excel 2007 export and header fixed issues please follow the below two steps.

1) Applying OBIEE bundled patch 11.1.1.7.140415
2) Enable below parameter as TRUE in xdo.cfg Configuration file.

"xlsx-keep-values-in-same-column" set to true  in xdo.cfg configuration file.
 
It will be available in below instance config BIJava Host components directory.


/obiee/Middleware/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1/
xdo.cfg 


<config version="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/">
<properties>
<property name="xlsx-keep-values-in-same-column">true</property>
</properties>
</config>


No comments:

Post a Comment