Controlling the order of dimension values

If a dimension's hierarchy has been created manually, you should also rank its dimension values manually. Default dimension value ranking is used with dimensions that are auto-generated.

There are two ways to control the order in which dimension values are returned. You can:

Manually rank dimension values.
Specify a default rank order.

In an auto-generated dimension, you generally don't have direct access to and, hence, can't manually rank, the dimension values (see the notes below for an exception to this statement).

Note:

You can load auto-generated dimension values and then rank them manually. See Editing auto-generated dimension values for details.
If dimension values are assigned ranks with values greater than 16,000,000, unpredictable ranking behavior may result.
A related feature allows you to prune the list of refinement dimension values returned for a query to those values that occur most frequently in the requested navigation state; that is, the refinement dimension values that are most popular. See Pruning dimension value refinements by popularity for more information.
For information on ranking dimensions, see Ranking dimensions manually.