The Correlation Matrix function calculates the strength of the relationships between all possible pairings of the specified data series as values between -1 and 1.
Zero implies that the two series are independent; a value close to 1 implies they are positively correlated, and a value close to -1 implies they are negatively correlated. A negative correlation means that when the first input is large, the second input is small, and vice-versa.
The Correlation Matrix requires the following input:
- d0 - The data series for which the Correlation Matrix is calculated. Must contain at least one data series.
The Correlation Matrix does not use any parameters.
The Correlation Matrix function generates the following output:
- Correlation Matrix – the Correlation Matrix result set containing a measure with the correlation values between pairs of measures, a hierarchy of measure names places on Rows, and a hierarchy of measure names placed on Columns in the metric set.