Setting the Evaluation Order

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

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 , 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) moves selected dimensions

   • (Move all items to) moves all dimensions

   • (Remove selected items from) removes selected dimensions

   • (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.