dbTalk Databases Forums  

Using STDEV

comp.databases.olap comp.databases.olap


Discuss Using STDEV in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nikhil Sharma
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.