Export to Excel and Export to CSV Format Produces a Different Column Order (Doc ID 1353652.1)

Last updated on JANUARY 14, 2014

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.
***Checked for relevance on 14-Jan-2014***

Symptoms

The following is observed with one particular analysis / report where the results are displayed in a Table view ...

1. In Answers, view the results of the analysis in the Results tab ... the columns appear in a particular order. 

For example, the columns and order may be like the following in the Results tab:
Year, Region, Brand, Revenue, Discount Rate

2. Click on the "Export this analysis" button > Choose "Excel 2003+" ... the columns in the Excel file are in the same order as per the Results.

For example, the columns and order may be like the following in the Excel file:
Year, Region, Brand, Revenue, Discount Rate

3. Click on the "Export this analysis" button > Choose "Data" > Choose "CSV Format" ... the columns in the CSV file are NOT in the same order as per the Results.

For example, the columns and order may be like the following in the CSV file::
Year, Brand, Revenue, Region, Discount Rate

The issue is that the data columns appear in one order when the users export the data to CSV Format, and the data columns appear in a different order when the users export the same data to Excel 2003+.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms