Hi,
I'm relatively new to OLAP/MDX and I'm using JPivot/Mondrian which
communicate using MDX. I've a set of scores in MS SQL Server and I've
set up a ROLAP star schema to access and aggregate them and everything
appears OK. I'm trying to calculate some simple statistics of the
grouped information, in particular trying to calculate the standard
deviation as a pre-cursor to doing some simple deviation
detection/error bars.
I've set up a second column of squared scores and I'm using a
member:

member [Measures].[Var] as
'[Measures].[Mean2]-[Measures].[Mean]*[Measures].[Mean]',
FORMAT_STRING = '###.00'

to calculate the variance, which appears to work. Is there a simple
way to take the square root of this? I've done a bit of searching and
the only lead was a couple of references to ^ as a power operator.
However, this doesn't seem to be standard mdx (from my reference
books) and I can find little on-line documentation about it? Any
ideas would be (either mdx specific or JPivot/Mondrian) would be much
apprectiated.
Thanks,
M