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

Viswanadham Apparao

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

Sherry George

Use custom format

Don't use excel to open the downloaded csv, use some other editor like wordpad.

Viswanadham Apparao

Thanks George for update.

We applied the same format in report level. And business wants to open CSV file in excel. So could you please provide me the solution if any to achieve this.

Thanks,

Viswanadham

Syedsalmancs110

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.

Sherry George

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

[Deleted User]

@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