Sometimes you need to categorize your data in a way that is not supported by your data warehouse. In that case, you will need to work with User Dimensions to create your own categories.
In this example (from the Finance cube), we have a dimension with Accounts (account numbers and names), and now we would like to create some general categories for these accounts.
We will start by adding a new User Dimension to the table:
The first member of the User Dimension can be created with the between operator and custom values:
Since the Account dimension members are strings, the above setting will dynamically include all accounts starting with ‘4’, e.g. ‘400005’ up until accounts starting with ‘5’ (not included).
In this way you can end up with a User Dimension with these custom Account Groups:
From the above, the ‘Tax’ member as an example: