This is probably the most common purpose for a user dimension: To create custom groups or custom categories on basis on basis of one or more standard dimensions.
In this example, we will looking at the Product dimension from the Sales cube. In this dimension we already have categories for Jeans, Shirts, T-Shirts and Underwear, but if we look closer at the individual products, we may also notice a number of brands, e.g. Armani, Boss, Levis etc. So why not make a new user dimension with according Brands groups?
The members of the Product Brands user dimension:
- Armani: From ‘Armani’ to ‘Armani, z’
- Boss: From ‘Boss’ to ‘Boss, z’
- Bosswell: From ‘Bosswell’ to ‘Bosswell, z’
- Levis: From ‘Levis’ to ‘Levis, z’
- Marlboro: From ‘Marlboro’ to ‘Marlboro, z’
Notice that the above members of the Brands user dimension are all designed with a between operator and with custom values.
E.g. for the Armani member:
Note: When using the Between operator for text values, you are in fact defining an alphabetical range. All text strings that would alphabetically fit between the From string and the To string, will be included.
The other members (Boss, Boswell, Levis and Marlboro) are defined in a similar manner.
The Product Brands user dimension will end up looking like this:
And the outcome may be used to produce something like this: