User Dimensions with Custom Groups

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.

mceclip0.png

We will start by adding a new User Dimension to the table:

mceclip1.png

The first member of the User Dimension can be created with the between operator and custom values:

mceclip2.png

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:

mceclip3.png

From the above, the ‘Tax’ member as an example:

mceclip4.png

 

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

Comments

0 comments

Please sign in to leave a comment.