Large product list handling. Sales planning.

Big dimensions are ep’s doom for sure. But nevertheless we need them to get going. Problem statement: A regional sales planning model to be created. 10k products(with product subgroups), spread among number of regions selling some subsets of product list (each subset is relatively small, about 2k els). Regions are contributors. Oh yes, cognos innovation…

Continue reading →

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 →