COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosnoise on 24 Mar 2016 01:55:43 PM

Title: How to use <= on cognos date in slicers?
Post by: cognosnoise on 24 Mar 2016 01:55:43 PM
Hi Folks,

First of all thanks for the plotform you created for knowledge share

I have a filter as follows in detail filter this is a DMR report

[Hierarchical].[Fiscal Calendar].[Fiscal Calendar].[Fiscal Date]<=?Selected Date?

but I am not sure how to use same filter expression in slicer.

Could you please help me on this.


Regards
Cognosnoise
Title: Re: How to use <= on cognos date in slicers?
Post by: bdbits on 28 Mar 2016 09:50:14 AM
I find this sort of thing is better done with the filter() function on one of the query data items.