Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MDX formula error: "Invalid MDX command with ,"

Hi,

I've been trying to set up a formula on an ACCOUNT member:

SUM({[TIME].[FY10.JAN]:[TIME].CurrentMember},([ACCOUNT].[SALESOWN],[CATEGORY].[ACTUAL]))

But it fails to process the dimension and returns an error message:

Failed to expand K2 function for dimension ACCOUNT's member formulas

MDX statement error:"Invalid MDX command with ,"

Obviously it does not like the tuple

([ACCOUNT].[SALESOWN],[CATEGORY].[ACTUAL])

even though it is a perfectly valid syntax. Besides, I have tried a similar formula in APPSHELL and it worked fine.

What could cause this difference of behavior from one appset to another?

Thanks

Regis

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question