Hi,
I am attempting to create a calculated measure that shows me the
Standard deviation of my source data. The goal is to put some
Statistical Process Control info "at a glance" in the OLAP cubes.
Unfortunately, I cannot find a way to use the STDEV() MDX function in
this manner. For instance, I have a SUM Parameter Value measure. If I
attempt to create a calculated measure as follows:

STDEV({[Measures].[Sum parameter value]})

it allows it, but it returns the Standard deviation of the SUMs. This
is very different than the standard deviation of all of the individual
members; moreover, it is very misleading.

Is it even possible to do this in OLAP? I've been looking around and
haven't seen this issue addressed. Please help!!!

--
Posted via http://dbforums.com