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

OP-ERR-0099 error code on aggregate function.

Started by vincydza@gmail.com, 20 Apr 2014 08:26:01 AM

Previous topic - Next topic

vincydza@gmail.com

Hi,

I have defined a member set
[All Method Type] =  [Presentation Layer].[Order Method Dimension].[Order Method Hierarchy].[Order Type]

Formula 1
When I add a query calculator to the report   aggregate(currentmeasure within  set [All Method Types]) I am prompted with the below error message
QE-DEF-0459 CCLE Exception
OP-ERR-0099 The DataItem="All method Types" does not exist in the query.

However formula 2 does not respond with an error.
Formula 2
Aggregate(Currentmeasure within set [Presentation Layer].[Order Method Dimension].[Order Method Hierarchy].[Order Type])

Why is the formula 2 successful and formula 1 failing,

What could be the issue.?

Vince