unary rollup and solve order -
09-14-2005
, 07:47 AM
Hi,
How does solve order affect unary operator calculations? Let's say I have
cube with 2 dims:
DimA
Total cost
unit cost (+)
number (*)
DimB
Total Unit
unitA (+)
unitB (+)
I would like AS to give result of sum ((UnitA,Total Cost)+(UnitB,Total
Cost)) on Total Unit instead of giving ((TotalUnit,Unit
Cost)*(TotalUnit,number)). Only on leaf members of DimB multiplications is
required.
I know how to do it with formulas, but I would like to use unary rollups to
simplify the calculation and make it more efficient.
"Understanding solve order and pass order" article describes this issue, but
I can not reach proper result.
As a test I have created two dimensions and both of them have following
structure:
DimA
Total cost
unit cost (+)
number (*)
Total Unit
unitA (+)
unitB (+)
DimB
Total cost
unit cost (+)
number (*)
Total Unit
unitA (+)
unitB (+)
Browse data gave interesting result where on Total Unit (no matter which
dimension) I had ((TotalUnit,Unit Cost)*(TotalUnit,number)) while in one
option I should have ((UnitA,Total Cost)+(UnitB,Total Cost)) . |