OBIEE Export to Excel 2007+ — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE Export to Excel 2007+

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

Hi All,

when we are exporting the analysis in excel 2007+ the date fields in the reports are showing as text fields instead of date. even if we try to change it excel is not allowing us to change. when we apply filter on the date fields it is showing as below.

C2.JPG

But we wanted to see them as below

C1.JPG

This is working fine in 2003 but not in 2007+. The version we are using is 11.1.1.7.140415 . How to fix/ achieve this in 2007+

Please help me with suggestions.

Thanks !

Answers