Problem with Current date function in filter

Cognos 8 Business Intelligence Report Studio
1

Hi everyone,

I have a problem with current date function in filter.

I´m using report where datasource is a cube, the report is working well but when i try to use the function “current date” in filter report return message above:

GEN-ERR-0015

   Initially, in data source type(s) 'pattern', function 'providerQuery' is not supported in 'OlapQueryProvider'. After decomposition, in data source type(s) 'PC', function 'ces_runningtotal' is not supported in 'OlapQueryProvider'

I´m using this function on data item in query of same report without error

Can you help me please ?

Thanks,

Jehovah Junior

2

hi,

i solved simular behaviour like this in the past:

  1. Be sure to use the Query Item instead of "from the hierarchy
  2. Use cast to convert date to string format to match caption() value:
    caption([Date1])=cast(current_date), varchar(10));
  3. If the format of two string in the above expression is different, use substring() to convert the format.