Using STDEV -
07-13-2004
, 08:12 AM
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 |