When multidimensional queries are executed, individual cells are evaluated. The order in which cell calculations should occur may be ambiguous. For aggregate storage databases, to remove ambiguity, you can use the solve order property to specify calculation priority for members and dimensions.
The value of the solve order property determines the priority with which a formula is calculated. The formula on the member with the highest solve order is calculated first.
You can specify solve order (between 1 and 127) at the member level or at the dimension level. Members with a solve order of 0 (the default value) inherit the solve order of their dimension. Members with the same solve order are evaluated in the order in which their dimensions are displayed in the database outline. Members with no solve order are evaluated after members with a solve order.
For information and examples about solve order, see the Oracle Essbase Database Administrator's Guide.
Note: | During dimension builds, you can use dimension properties to specify calculation order. |
To specify calculation order for formulas in aggregate storage databases:
Open an outline in edit mode.
The Outline tab is displayed.
Right-click a dimension or member, and select Edit member properties.
In the Member Properties dialog box, select the Information tab.
In Member solve order, enter a number representing the placement of the formula attached to the selected member or dimension within the order of calculations.
Click OK.
“Calculation Order” in the Oracle Essbase Database Administrator's Guide