Setting the Evaluation Order

The Evaluation Order tab enables you to specify which data type prevails when a data intersection has conflicting data types.

For example, if Account members are set to the Currency data type, and Product members are set to the Smart List data type, you can set whether the Currency or Smart List data type prevails at an intersection.

Note:

Account members that require Text, Date, or Smart List data types, require the Account dimension to have an Evaluation Order set for the cube or cubes in question.

To set evaluation order:

  1. From the Home page, click Navigator Navigator icon, and then under Create and Manage, click Dimensions.
  2. Select Evaluation Order, and then select the cube.
  3. Select an action to move selected dimensions into or out of Selected Dimensions:

    • Move selected items to icon (Move selected items to) moves selected dimensions

    • Move all items to icon (Move all items to) moves all dimensions

    • Remove selected items from icon (Remove selected items from) removes selected dimensions

    • Remove all items from icon (Remove all items from) removes all dimensions

    You need to select only dimensions whose members have specific data types (that is, their data type isn't "Unspecified"). The data type "Unspecified" doesn't conflict with another data type.

  4. Set the order of precedence for dimensions in Selected Dimensions by clicking the move arrows to the right of the Selected Dimensions pane.
  5. Click Save.