MS is going to CPM

Analytic article on subject And antoher So MS is out here on CPM market, gaining force by name and customer list. In my opinion it sounds rather bad for other “pure BI” players, like Cognos, BO, MSTR, Applix and so on. As far as I can see, those vendors are only developing fully-integrated CPM solutions…

Continue reading →

EP. Dimension order. Small example.

Common question: how dimension order affects calculations? Because calculation order appears only in cross-dim calculations, we can create following sample cube (x’s are inputed): c d c/d a x1 x2 x1/x2 b x3 x4 x3/x4 a+b x1+x3 x2+x4 ??? The ??? marks the trouble spot. It can be: 1) (x1+x3)/(x2+x4) 2) (x1/x2)+(x3/x4) Calculation sequence is…

Continue reading →