If I use



Correlation([TIME].CURRENTMEMBER.CHILDREN,

(PRODUCT.CURRENTMEMBER, [TIME].CURRENTMEMEBR, measures.sales),
(PRODUCT2.CURRENTMEMBER,

[TIME].CURRENTMEMBER, measures.sales))





What will be the X,Y values for correlation calculations i.e

will it be calculated over [time].currentmember.children



Or it will be calculated over [TIME].currentmember



Its accepting the above syntax, but its confusing that what

result it will give.



Thanks


--
Posted via http://dbforums.com