dbTalk Databases Forums  

unary rollup and solve order

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss unary rollup and solve order in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kuba
 
Posts: n/a

Default 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)) .



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.