Hi All,

The information in SQL Server BOL on the subject matter is very confusing.
Here are the 2 statements from BOL

"Calculated members are resolved before custom rollup formulas and custom
member formulas are resolved."

"Custom rollup formulas have a default solve order of -5119 and calculated
members have a default solve order of 0" According to the second statement
Custom Rollup formula will be calculated before calculated members.

Can anybody help me with the 3 questions as under:
1.What is the correct defalut order of calculation for calculated members,
custom rollup formula and custom members(when we don't set any solve order).
2.How can I change the solve order of "Custom Rollup formula".
3. What will be order of calculation if calculated member, custom rollup
formula and custom member have the same solve order.

Thanks