If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to implement "having" clause in FM

Started by kalyan_y, 22 Jul 2009 11:58:35 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

kalyan_y

22 Jul 2009 11:58:35 PM
Hi...
   Can anyone suggest how to implement "having" clause in FM

kalyan_y

#1
23 Jul 2009 06:50:23 AM
I got that.....

bl

#2
12 Aug 2009 10:38:25 AM Last Edit: 12 Aug 2009 10:40:59 AM by bl
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
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite