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!

Oracle Analytics Cloud and Server

2660624 · 2018-07-30 08:18:37

Hi, I am using sql server as data source in obiee 11g but when I am using any date field in filters in reports its giving error as : [ODBC SQL Server Driver][SQL Server]'TO_DATE' is not a recognized built-in function name. I checked the physical query and found that to_date is applied in where clause. The report is working…

Date filter having sql server as data source not working in obiee 11g

Received Response

Views

Comments

Answers

2660624 Rank 3 - Community Apprentice

Jul 30, 2018 12:48PM

Fixed the issue by creating dummy report having column with hard coded date value in the format required by bi server and use it in the main report in filter.

Now physical query is not using TO_DATE function : T835376.DTTMRECIEVED >= '2017-01-01'.

Thank you guys. Really appreciate your help.

0

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Date filter having sql server as data source not working in obiee 11g

Answers