Filter in Cognos

[yoniw]

Hi all,
We are using Congos 10.2 On Linux server using Vertica DB.

When we were using Oracle, we used a filter for time with this pattern:

#'[RadcomDB].[CDR_GN].[START_TIME]'#>= to_timestamp(#sq(prompt('Begin Date','DateTime'))#,'yyyy-mm-dd hh24:mi:ss.ff') - #$SP_Offset#/24and#'[RadcomDB].[CDR_GN].[START_TIME]'#<to_timestamp(#sq(prompt('End Date','DateTime'))#,'yyyy-mm-dd hh24:mi:ss.ff') - #$SP_Offset#/24

and we have this filter in every query subject with a minor change of the table name(cdr_gn).
(this works and valid in FM).


part of our upgrade to Vertica DB, is to instead using filter for every query subject, is to use the same filter for all tables ->

[START_TIME]>= to_timestamp(#sq(prompt('Begin Date','DateTime'))#,'yyyy-mm-dd hh24:mi:ss.ff') - #$SP_Offset#/24and[START_TIME]<to_timestamp(#sq(prompt('End Date','DateTime'))#,'yyyy-mm-dd hh24:mi:ss.ff') - #$SP_Offset#/24


and with this way - we do not need to change anything and the time filter will always fit the query.

we encountered a problem - > the filter of course isn't valid in FM, but when we use it in RS it works, but it works slowly (and when we are using the path [RadcomDB].[CDR_GN].[START_TIME] it works fast!)

do you know why?
BR
Yoni