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.
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)