Obtaning correlation coefficient from data mining model

Question

Hi guys.

I want to be able to get the correlation coefficient by comparing a sales time series with different variable time series.

I want to compare the sales with variables 1 by 1 so i can choose what variables to consider for prediction purpose latter.

I know there is a MDX function called CORREL. But since i´m going to apply data mining models latter, i would like to know if there is any DMX or other way of getting the correlation coefficient from the two time series with data mining structures.

Best regards,
Helder Borges

Answer 1

Helder,

Você poderia descrever um pouco do seu ambiente?

Could you describe a little of your environment?

---

Pedro Antonio Galvão Junior [MVP | Microsoft Evangelist | Microsoft Partner | Engenheiro de Softwares | Especialista em Banco de Dados | SorBR.Net | Professor Universitário | MSIT.com]