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:
Comments
Imagine I would like Bosswell and Levis together in 1 brand.
Is it possible to do:
BRANDX:
From ‘Bosswell’ to ‘Bosswell,
OR
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?
Hi Jora,
Yes, you can do a combination of multiple brands. Just keep adding the required filters to your user dimension member like this:
BR / Ole
Hi Harry,
Unfortunately, the "including" function does not work with the Custom value option.
The "including" option will only work when you do a search in a dimension. Then you can search for 'armani' and then it will find all the examples, you mentioned.
However, it will only find the members that exist at the moment you do the search. It cannot be used to find and filter on any future members.
Note: When working with Custom values and the equal to option, you can put in a comma separated list of current and future members, like this:
BR / Ole
When I add an extra filter it doesn't show anything.
It acts like both conditions should be met: DocumentNo should be in collection 1 AND collection 2.
Instead I would like an OR.
That is strange, Jora.
As you can see, when I add my two conditions (here as a local criteria) they indeed work like an OR.
Have you tried running them one at a time? Just to see that they actually work.
BR / Ole
Please sign in to leave a comment.