Exporting Oracle BI Analysis from Oracle BI EE 11.1.1.8.x or Earlier Releases to Excel Files

Settings in the xdo.cfg configuration file specify the format for exporting analyses to Excel spreadsheets.

Sometimes, the exported Excel file doesn’t maintain the exact look-and-feel of the analyses. For example, you might notice that columns in the exported file are wider than in the analyses and that any field that has merged cells fits into a single cell. These situations occur because the export to Excel works in a columnar formatting mode, in which all data fields map to specific columns in the exported file.

In the <DOMAIN_HOME>/bi/config/fmwconfig/biconfig/OBIJH/xdo.cfg configuration file, you can specify the way to export analyses to Excel spreadsheets:

• If you need to use the Excel export for data ingestion in another application, then set the xlsx-keep-values-in-same-column property to true.
• If you need to use the Excel export for viewing or printing the output, then set the xlsx-keep-values-in-same-column property to false.
• If your organization needs exported files for both data ingestion and viewing and printing good-looking output, then you can set the xlsx-keep-values-in-same-column property to true, and set the maximum column width to a suitable value (for example, 100 points).

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