Avg / Median - Newbie Question

[HRoarke]

Hello all,

Have a simple cube containing a few numeric measures and three dimensions. I need to calc the Avg and Median of the numeric measures across a given dimension for all members and for each member. The query

SELECT
   avg([Operating Budget].members, [Measures].[a particular numeric measure]) on 0
FROM  [Pay Increase]

returns "cannot convert expression to Set - in a statistical set 1" error. However, I KNOW that .members returns a set; I've tried enclosing the expression in () and {} to no avail. Any suggestions? Adding a calculated member would be acceptable as well, but no love there either.

Sorry if this is a brain-dead question, but I'm STUMPED.

Also, can anyone recommend a good MDX query tool, e.g. something a little better than the MDX Sample App that comes with AS?

BTW, I'm using AS for SQL2K, sp4.

Thanks in advance,

"I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine."
— John Galt
Atlas Shrugged

If you want to get the best response to a question, please check out FAQ222-2244 first

 

[HRoarke]

Please disregard this question - bad cube design....

The learning curve for AS is quite a bit steeper than one may reasonably expect!

"I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine."
— John Galt
Atlas Shrugged

If you want to get the best response to a question, please check out FAQ222-2244 first