I wanted to calculate the standard deviation for processing time of
workflows.
I have a dimension as 'Workflow Name' and have a level as 'Workflow
Version'
I have a measure as 'Processing Time'.
When ever a workflow completes we put an entry into the facttable with
processing time.

So suppose i have Workflow1,Workflow2 and if 6 runs of workflow1 and 5
runs of Workflow2 have been completed the fact table will have a total
of 11 (6+5) rows enterd with 'Processing Time' for each run.

i want to calculate the standard deviation for Processing Time for all
the runs of workflow1 and workflow2.

How can i do this using STDEV MDX function.


Thanx in advance

Nikhil

Assuming that you always wish to calculate the standard deviation of
Processing Time for all the leaf nodes under a selected member of the
[Workflow Name] dimension:

[Measures].[Processing Time])

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!