Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Loading and Retrieve Dates in Correct Format

Received Response
41
Views
3
Comments
Nicholas Kollauf
Nicholas Kollauf Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

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

  • GlennS_3
    GlennS_3 Rank 4 - Community Specialist

    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

  • Nicholas Kollauf
    Nicholas Kollauf Rank 2 - Community Beginner

    Good idea, I just tested in SV and it retrieves as suspected so it appears to be a Dodeca issue :(

  • Nicholas Kollauf
    Nicholas Kollauf Rank 2 - Community Beginner

    I may have solved this on my own, looks like the “Use Smartlist” option in Dodeca options needs to be enabled/checked.