tags:

views:

37

answers:

1
+1  Q: 

Using MDX Correlation() function to find correlation of 2 dimentional members.

I'm trying to find the Pearson correlation of a single measure between two members of a dimension, but the msdn docs are a bit sparse. Specifically I have a cube with a fact count measure, a date dimension, and a tool dimension and I'd like to find the correlation of tool X and tool Y over the date dimension.

related questions

Algorithm to score similarness of sets of numbers
Recommend an Open Source .NET Statistics Library
What does "Create Statistics" do in SQL Server 2005?
Opensource Implementation of the Alias Method
How to get the temperature of motherboard of a PC (and other hardware statistics)?
What would a Database Diagram (ER Diagram/Table Layout) look like for measuring distribution of something?
Explain the quantile() function in R
How do you visualize logfiles in realtime?
Statistically removing erroneous values
What is the best Java numerical method package?
Probability of finding TCP packets with the same payload?
What's the correct term for "number of std deviations" away from a mean
How often should Oracle database statistics be run?
What emails clients are being used out there?
[R] How to access the last value in a vector?
What is the easiest way to get total number for lines of code (LOC) in SQL Server?
Hidden Markov Models
What is the deployment rate of the .NET framework?
How do I calculate the "cost" of a crash?
How do i generate a histogram for a given probability distribution (for functional testing a server)
Call Visitors web stat program from PHP
Is it OK to drop sql statistics?
How do I display database query statistics on Wordpress site?
User access log to SQL Server
How do I calculate these statistics?