Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Loading and Retrieve Dates in Correct Format
Summary
Loading Dates formatted as mm/dd/yyyy type but they retrieve in scientific notation
Content
The outline has the date type enabled.
The date fields that are loaded are tagged as date types.
Information loads correctly and I have confirmed the load file (.csv) has the dates formatted as mm/dd/yyyy.
When I go to retrieve (using the Dodeca Add-In), the dates retrieve in scientific notation (1.XXE+09) instead of mm/dd/yyyy.
Has anyone else encountered this problem and know a fix?
Answers
-
I would actually contact Applied Olap support (They are really good). My guess is in Dodeca, the cells are being set as numeric.. I would also double check in Smart View to make sure the issue is Dodeca
0 -
Good idea, I just tested in SV and it retrieves as suspected so it appears to be a Dodeca issue
0 -
I may have solved this on my own, looks like the “Use Smartlist” option in Dodeca options needs to be enabled/checked.
0