COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: wskacz on 10 Dec 2009 12:30:30 PM

Title: SQL Where statement in FM?
Post by: wskacz on 10 Dec 2009 12:30:30 PM
New to Cognos.  Just want to filter by date i.e. take the records that have a date > = Dec 1 e.g. a filter  without having to build an expression.  Help... 
Title: Re: SQL Where statement in FM?
Post by: blom0344 on 11 Dec 2009 03:44:30 AM
There is more than one way to achieve this. Adding it to the SQL definition is very definitive. It makes more sense to filter from reports (unless there is a absolute reason to shy away from certain dataranges.
Perhaps a stand-alone filter will suit your purpose?