OBIEE 12c: Custom Date format issue while exporting the report into CSV

Question

Hi All,

Currently I am using OBIEE 12c. In report level we have applied the custom DATE format like  YYYY-MM-DD. while export it into CSV it is showing like MM/DD/YYYY.

But as per business, in CSV file also we need to show the date format like in report i.e YYYY-MM-DD.

Can anyone please help me to resolve this.

Thanks,

Viswanadham

[Deleted User] · Answer

@Viswanadham Apparao instanceconfig.xml has a host of new export settings since 11.1.1.9 which include RawValue vs FormattedValue options for Excel exports:

Performing General Configuration Tasks for Analyses

Sherry George · Answer

The issue is with MS Excel and not OBIEE. If they must use Excel, they can import the data from the .csv file using the EXCEL Data tab and could use 'text' as data type for the date field.

https://support.office.com/en-us/article/Text-Import-Wizard-c5b02af6-fda1-4440-899f-f78bafe41857?ui=en-US&rs=en-US&ad=US

Syedsalmancs110 · Answer

This is looks to be correct behavior as CSV format is plain text and It is not supposed to preserve formatting If you need formatted output, use Excel 2007+ export.