Skip to content

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 defined by dimensions order. By pressing F7 on that cell you can see dimension order, and therefore the calc sequence.
+ and / are selected, because + and * are commutative. Got meself caught a couple of times.