Print Page - How to implement "having" clause in FM

Title: How to implement "having" clause in FM
Post by: kalyan_y on 22 Jul 2009 11:58:35 PM

Hi...
Can anyone suggest how to implement "having" clause in FM

Title: Re: How to implement "having" clause in FM
Post by: kalyan_y on 23 Jul 2009 06:50:23 AM

I got that.....

Title: Re: How to implement "having" clause in FM
Post by: bl on 12 Aug 2009 10:38:25 AM

Few ways i think

* Use a filter in the Summary Filter section of ReportStudio (or QueryStudio)
* Make the filter in FM filter a value against an aggregate function... Ex: total([amount]) = 100 That should force the query to group the data and filter against the summed value

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: kalyan_y on 22 Jul 2009 11:58:35 PM