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

Aggregation Issue

Started by k2, 16 May 2011 09:25:44 AM

Previous topic - Next topic

k2

Warning Error Message :

RQP-DEF-0579 Warning: The footer aggregate operation 'aggregate' for the data item '' cannot be expressed in terms of the underlying subquery The result set may contain duplicate rows.

I have a Currency conversion filed which got calculation in Framework Manager, when I use that field in Report with grouping it is not giving the total value for specific groupings but gives the sum value for the total report. I guess, it is an issue with aggregation. Could someone help me out how to fix this please. The above mentioned error message pops up when i validate the report.

Please let me know if any further information required. Thanks