Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 306 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 22 Oracle Analytics and AI 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