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