If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

date functions and reports based on user defined SQL

Started by Ricky@MDPD, 10 Sep 2008 12:42:18 AM

Previous topic - Next topic

Ricky@MDPD

Is there any known compatibility issues with using some date functions in a report that is based on a used defined SQL (cognos 8.3). My report queries an oracle database (10G)works fines when i'm not using a date finction, but when I add the follwing filter
-----------------------------------------------
[Main Query].[INCIDENT_DATE] between
to_date( '01-JAN-'||substr(?compl month?,1,4))
And
to_date( ?compl month?, 'yyyy/mm' )
-----------------------------------------------------
I get the following error msg:

-----------------------------------------------
GEN-ERR-0015
Initially, in data source type(s) 'OR', the function 'ces_currentmeasure' is not supported in 'RelationalQueryProvider'. After decomposition, in data source type(s) 'PC', the function 'fn:to_date' is not supported in 'OlapQueryProvider'.
-------------------------------------------------------


m23

That filter works fine for me. some suggestions ..

Check that the oracle function set is available for use in your package. You can do this by dbl clicking the filter. Click the little F(x) box. open the vendor specific functions folder. You should see oracle in there.

You could apply the filter directly in your sql satement. Just add the following to your sql statement

and incident_date between
to_date( '01-JAN-'||substr(#prompt('compl month')#,1,4))
And  to_date( #prompt('compl month')#, 'yyyy/mm' )