Using CurrentMember in the Order MDX Function?

[bonniehsueh]

I'm trying to use the currentMember function in the order function, but am getting this error when I use the currentMember function.

PCA-ERR-0062 The "currentMember" node is not expected to be a "qs:member". 

This is the expression I'm using: order(currentMember([great_outdoors_company].[Products].[Products]),#prompt('pSortColumn','token','tuple([Americas],[Americas Current],[Revenue])')#,desc)

Since members can be used in the set expression of the Order function, I would expect the currentMember function should also be compatible.

What am I missing? Any ideas would be appreciated! 

Thanks in advance.

[CognosPaul]

First question, is this a real cube or DMR?

The currentMember will always return a single member, order will work with a single member, but it won't do anything. Try order(children(currentMember([great_outdoors_company].[Products].[Products])),#prompt('pSortColumn','token','tuple([Americas],[Americas Current],[Revenue])')#,desc)