EP. Dimension order. Small example.
June 20th, 2006Common 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.
