Creating a sift dimension hierarchy

Defining a sift dimension is a two-step process. First, you create the sift dimension hierarchy, then you specify that the dimension should use auto-generation during its mapping process.

1. In the Dimensions view, create a new dimension.
2. Add dimension values to the dimension and define them as Sift by doing the following:
   1. In the Type list, choose Sift.
   2. From the Bound Type list, choose one of the following: String, Floating point, or Integer.
   3. In the Lower Bound text box, enter the lower number in the range.
      Note: If you want the range to include the number you enter, check Include value in range.
   4. In the Upper Bound text box, enter the higher number in the range. If you want the range to include the number you enter, check Include Value in Range. This illustration shows how to set the range for the Q - T dimension value.
      Note: By specifying R as the upper bound for the Q dimension value, but not including it in the range, we ensure that all strings that begin with Q are included in the range, such as Queen, Quick, QWERTY, and so on.
   

   This illustration shows how to set the range for the Q dimension value.

   
3. Click OK to close the Dimension Value editor.
4. Continue to populate the dimension with sift dimension values as needed. This illustration shows what the Dimension Values editor looks like for the example established in this procedure.