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.

I tried with Data Direct 6.0 SQL Server wire protocol. But getting same issue as: [DataDirect][ODBC SQL Server Driver][SQL Server]'TO_DATE' is not a recognized built-in function name.. (HY000) State: HY000. Code: 16002. [nQSError: 16002] Cannot obtain number of columns for the query result. (HY000) SQL Issued: SELECT…

Datatype is TIMESTAMP when I import it.

Its simple date column whose datatype is TIMESTAMP. I tried with DATETIME too but doesn't solve the issue.

Its ODBC 3.5 as call interface and driver as sql server. You were right I am getting to_date without applying any logic.

I am not getting any error but its taking me to web page having same url name as repository variable name as shown below. OBIEE version is 11.1.1.9. Yes variable works fine in standalone as i tested in column formula as . Regards

I can do that but that's not what I am looking at. We have used the web action link in multiple reports. The url which we are using now got changed and in future too it will change. So instead of changing the url in each report we used the repository variable so that we can change the url in just one place.…

Can I pass the column values if I does so?? I have to pass two column values for that action link.

Hi Joel, User wants to change the operator dynamically in the prompt and in variable prompt there is no option for operator change as its available in column prompt. Thanks, Milan

In variable prompt there is no option for Operator selection. Its only available for column prompt. Due to that I haven't used variable prompt.