Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c: Custom Date format issue while exporting the report into CSV
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
Answers
-
Use custom format
Don't use excel to open the downloaded csv, use some other editor like wordpad.
0 -
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
0 -
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.
0 -
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.
0 -
@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:
0