The solve order number determines the order by which members are evaluated in the dimension. You can select a number between 1 and 127. The member with the highest solve order number is evaluated first (for example, a formula with a solve order number of 20 is evaluated before a formula with a solve order number of five).
Members with the same solve order number are evaluated in the order in which their dimensions appear in the database outline. Members with no solve order number are evaluated after all members with solve order members.
Note: | The default value is 0. Members with a solve order of 0 inherit the solve order of their dimension. |
In the Dimension Solve Order text box, specify a number to represent the default order by which members are evaluated in the dimension. You can specify a solve order between 1 and 127. The default value is 0. In the Member Solve Order text box, specify the solve order for the dimension member. For example, in the Market dimension, Market is the dimension member.