Help with STDev

Last Post 24 May 2002 04:47 AM by bmccaig. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
New Member
New Member

24 May 2002 04:47 AM
I have a STDev MDX Calculated measure to create.

I have the following dimensions:

Job Family [3 Members]
Job Titles [120 Members]


I have the following Measures:

Pay Rate What we pay our Associates
Bill Rate What we Bill our Customers
Associates People we place in jobs

I have created Bill Mean Calculated Measures [sum(Bill Rate)/Count of Associates] same for Pay Rate Mean . This works just fine.

I want to show:
Pay Rate Low Pay Rate Mean Pay High Pay Rate
STDev – Mean Mean STDev + Mean

Same report for the Bill Rate.

I am having trouble conceptualizing how to go about creating the STDev.

What I have currently :
For Straight STDev of Bill Rate
Stdev([Job Family].[Job Title Name].members,[Bill Rate Mean])
This yields a result that seems to be uniformly applied across every Job Title.
I need it to be a unique calculation for each Job Title.

I tried:
Stdev(«Set»[, «Numeric Expression»])
Stdev(«Dimension».CurrentMember[, «Numeric Expression»])
Stdev([Job Family].[Job Title Name].CurrentMember[, «Numeric Expression»])

For «Numeric Expression» do am using the raw [Pay Rate] value.

With the above MDX Expression, I am seeing ONE value calculated for all of the Pay Rate Column , likewise with the Bill Rate Column.

As you can see I am a bit confused about how to proceed.

Any help would be greatly appreciated.


Brian McCaig

You are not authorized to post a reply.

Acceptable Use Policy