Selecting the Member Calculation Solve Order

The solve order determines the order by which members are evaluated in the dimension.

For information on using the solve order option, see Solve Order Overview.

  To select a solve order:

  1. Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.

  2. Select the Info tab.

  3. Locate the Solve Order group.

  4. Select a Solve Order option:

    • Member Solve Order—In the text box, specify a number between 1 and 127 to represent the order in which the dynamic hierarchy is evaluated. The default is 0.

    • External Source—In the drop-down list, select the column in the database that contains the order in which members are evaluated.

      Note:

      The From Database Column drop-down list box is not available for members of user-defined dimensions or accounts dimensions that come from the fact table.

  5. Click Apply.

    Note:

    To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.