I know that it isn't SQL and that will have to use different objects from VB (different from the Recordset object).

Don't you have any web reference? For now I only need to evaluate if I can calculate a correlation matrix from our own data (stocked in SQL tables).



>You won't be able to use this function in SQL. It's an MDX function.
>
>If you're starting to dive into Analysis Services and MDX, I'd suggest the following book:
>http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0471400467&vm=
>
>Also be warned that MDX is not SQL. It's set oriented, recursive, and iterative all at the same time <s>
>
>-Mike
>
>>Does anyone have a sample (or doc or website) of using the correlation operator in SQL ?