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

Cognos 8.4 RQP-DEF-0578

Started by wtrost, 12 Feb 2009 09:58:19 AM

Previous topic - Next topic

wtrost

Has anyone seen this error message before?  We are working on upgrading from 8.2 to 8.4, and some reports are returning this warning during validation.

RQP-DEF-0578 A grand total will be returned for measure 'Ordered Quantity' in expression '[Product Sales].[Product Sales].[Ordered Quantity]' Either the reporting context of this expression does not define an appropriate scope or the measure is not aggregated.

cognosguru

Just saw the same thing.  Will be checking into it with IBM.  Let me know if you find something.  Thanks.

RQP-DEF-0578 A grand total will be returned for measure 'Open Claim Count' in expression '[Facts].[Claim AsOf Fact].[Open Claim Count]' Either the reporting context of this expression does not define an appropriate scope or the measure is not aggregated.

wtrost

I think since I posted this, we found that it tended to occur most often when combining some dimensional objects with some relational objects.  Since there's no scope relationship between the two objects, a warning gets thrown.  Scope relationships only exist between dimensions and facts.

jmsellner


MFGF

Hi,

For the 8.4 release, many of the syntax checking rules were tightened up, and consequently, expressions which previously parsed successfully suddenly started to flag up warnings or errors in 8.4.  In all cases I have seen, the expressions or constructs were not strictly legal anyway, and exploited "loopholes" in the parser in prior releases, or were ambiguous in their scope etc.

If you are seeing particular errors or warnings, post them up and we can try to suggest alternative (more legal) ways of expressing things.

Regards,

MF.
Meep!

jmsellner

I am getting RQP-DEF-0578 ; Either the reporting context of this expression does not define an appropriate scope or the measure is not aggregated, on a report where the package has a DMR.  The report is group on two fields that come from another fact query subject area.

I am trying to summary the timeliness measure from Fact A and the groupings are from a hierarchy in dimension 1 associated with Fact B.  Fact A and Fact B are joined based on another dimension 2.

Fact A n-1 Dimension 1
Fact A n-1 Dimension 2
Fact B n-1 dimension 2


Is this because Dimension 1 doesn't have scope set for Fact B?  Since it doesn't have a direct relationship, if this is a scope problem how should I go about correcting this since there isn't a direct relationship?