The MDX function CURRENTMEMBER failed because the attribute contains a set.

[oscarca]

Hey Cognos,

Anyone familiar with how to solve this error?
"The MDX function CURRENTMEMBER failed because the coordinate for the 'ItemTypeLevel1IDName' attribute contains a set.
RSV-SRV-0042 Trace back:
"
I Have localized the issue to this data item:
tuple([Actual];[Quantity Net Weight];[7 Invoiced])/tuple([Actual];[Quantity Net Weight];[7 Invoiced];[Summary(Item Type)])

and it seems like its complaining about [Summary(Item Type)] which looks like this:
member(aggregate(currentMeasure within set [Item Type]);'itemType';'itemType';[CBI Sales].[Item].[Item Type])

I assume here that the reason for the error is that the data item Summary(Item Type)] generates a set which is later used here:
tuple([Actual];[Quantity Net Weight];[7 Invoiced])/tuple([Actual];[Quantity Net Weight];[7 Invoiced];[Summary(Item Type)])


[Item Type] data item looks like this:
[CBI Sales].[Item].[Item Type].[Item Type Level 2]

So the real question would then be how to rewrite the code.
Thank you Cognos Community for always being great help.

[oscarca]

*Solved it*

By changing: member(aggregate(currentMeasure within set [Item Type]);'itemType';'itemType';[CBI Sales].[Item].[Item Type])
to member(total(currentMeasure within set [Item Type]);'itemType';'itemType';[CBI Sales].[Item].[Item Type]).

Seems like it generated a set even though I declared it as a member when I used aggregate...