Print Page - Error due to Running-Difference in my report

Title: Error due to Running-Difference in my report
Post by: venkiatmaruthi on 24 Feb 2011 08:15:35 AM

Hi,

I am migrating the a report from 8.2 to 8.4.1.
I am having one query item in 'Differece' which is having the below calculation.
running-difference([Utilization (%)] for ([DATE_COVERED]))

I am using the Difference in one variable as [Utilization first run].[Difference] > 0

This difference is query item is giving the error/Warning

QuoteRQP-DEF-0566 The scope (FOR-clause) of the running aggregate for projection#: 8 'Difference' is not consistent with the ORDER BY of the query.

Don't know how to fix it. Please help.

Title: Re: Error due to Running-Difference in my report
Post by: venkiatmaruthi on 25 Feb 2011 12:00:39 AM

Please hlep. No one didnt get this type of issue.

Title: Re: Error due to Running-Difference in my report
Post by: VRobert on 28 Feb 2011 01:53:39 PM

Hello

This can help :

https://www-304.ibm.com/support/docview.wss?uid=swg21446723

V

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: venkiatmaruthi on 24 Feb 2011 08:15:35 AM