COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: vincydza@gmail.com on 20 Apr 2014 08:26:01 AM

Title: OP-ERR-0099 error code on aggregate function.
Post by: vincydza@gmail.com on 20 Apr 2014 08:26:01 AM
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