Wednesday, 15 June 2011

ssas - MDX error with aggregate -


Text after "

I MDX

  create member CURRENTCUBE. [Measure] with the following query. [Accuracy of labor hours] as the amount of assessment (case is when (1- [measure] [assessment difference] / gross ([measure] [real labor hours], [districts], [district], [ Work D] [Work.] [Job Description])) * 100>. 0 then (1 - [measure] [assessment difference] / gross ([measure] [actual labor hours], [districts] ], [Work de.] [Work]. [Job description])) * 100 ELSE 0 END), VISIBE = 1, ASSOCIEUUURUUURU = 'workf';  

I got the following error

MdxScript (Test) (52, 71) The AGGREGATE function was given a lot of arguments. Maximum argument number for function is 2.

How to solve it?

The error is easy to understand by most MDX error messages

You can get this snippet There are three arguments:. [work] [job description]) P> Here is the MSDN definition: ...

Gross (Set_Expression [, Numeric_Expression])

After this definition, move your Numeric_Expression to the end and other expressions in front of it: / P>

   

There should still be error then you will have to prepare one of the first two arguments:

  gross ({([ District [], [Work D]. [Work] [Job Description] [}}, [Measure]. [Real labor hours])  

Your error message should now go .


No comments:

Post a Comment