User Dimension for custom Grouping

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:


Was this article helpful?
0 out of 0 found this helpful


  • Imagine I would like Bosswell and Levis together in 1 brand.
    Is it possible to do:


    From ‘Bosswell’ to ‘Bosswell,
    From ‘Levis’ to ‘Levis, z’

  • Imagine I would like to see everything that includes "Armani".


    For Example:

    - Shirt Armani XL

    - Shirt Armani S

    - Shirt black Armani S

    - Shirt white S Armani


    Is it possible?


Please sign in to leave a comment.