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.

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. From Available Dimensions, select dimensions and move them to Selected Dimensions:

   • moves selected dimensions

   • moves all dimensions

   • removes selected dimensions

   • removes all dimensions

   You need 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. If you select multiple dimensions, set the order of precedence by clicking or .
5. Click Save.