When the OBIEE report is exported to Excel 2007 date columns are saved as text instead of date — Oracle Analytics

Oracle Analytics Cloud and Server

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

When the OBIEE report is exported to Excel 2007 date columns are saved as text instead of date

Received Response
1
Views
2
Comments
3174977
3174977 Rank 5 - Community Champion

Hi All,

When I am exporting OBIEE report into excel 2007 all the date fields are saved as text instead of date. How to resolve this issue. Please help with suggestions. With this the users are not able to sort or filter based on date fields.

Thanks !

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    this is fixed in Version 11.1.1.7.150120(Patch 20124371)

    whats your version?

  • 3174977
    3174977 Rank 5 - Community Champion

    Hi Srini,

    we are using 11.1.1.7.140415 . Actually my case is when I am exporting my report which has date fields it is showing as below.

    C2.JPG

    But when we apply filter on date fields we wanted to see as below.

    C1.JPG

    When we export the analysis in 2003 it is working as expected. But in 2007+ it is not working. How can this be achieved in 2007+.

    Please help me with suggestions .

    Thanks !