Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

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

Comments

Hi Christian, If i open the .csv file in notepad++ it showing the correct value as "Nov-17". Thanks, Somi

in Difference in date format between .xlsx and .csv file in obiee 12c Comment by 3364275 Feb 8, 2018 8:35AM
Please let me know if the below screenshot helps.

in Difference in date format between .xlsx and .csv file in obiee 12c Comment by 3364275 Feb 8, 2018 6:56AM
Hi, Just an FYI. 1)For that date column in obiee RPD is Varchar(50). 2)In database date value eg:- Nov-17,Oct-16...

in Difference in date format between .xlsx and .csv file in obiee 12c Comment by 3364275 Feb 8, 2018 6:51AM
Hi Robert, Its a direct pull from the database. we didn't use any column format. In database it is showing (17-may). So in obiee analytics it is showing correct value (17-May). But if we export it to .csv format it showing 17-05-2018.

in Difference in date format between .xlsx and .csv file in obiee 12c Comment by 3364275 Feb 8, 2018 6:06AM