As with any other dimensions, you can also promote a User dimension to become a filtering option on your Criteria bar.
Right click the User dimension to add it to the Criteria bar:
This feature is great value, especially when working with User dimensions with custom Dynamic criteria:
Notice: You cannot add Local User dimensions to the Criteria Bar. A User dimension must be Shared before it can be added to the Criteria Bar.
Multi-select user dimension members
In example above, the user dimension members can only be single-selected (the radio buttons).
To be able to multi-select user dimension members, you must enable 'Multiselect' when designing the user dimension:
To allow multi-select on a user dimension, it must adhere to these rules:
- The members must be designed from the same dimension, and only from one dimension.
- The operator must be either 'equal to' or 'between'.
- The members of the user dimension must use the same operator. I.e. you cannot have one member using the 'equal to' operator while the other members use the 'between' operator.
- Often, an 'equal to' operator can be changed to a 'between' operator, if necessary. Example: Equal to 'This month' can be changed to Between 'This month' and 'This month'.
- Member properties does not work together with multi-select.
Technical note:
The technical reason why multiselect works, is that the way criteria are applied, it does not make it possible to make separate criteria from one dimension depend on criteria from another dimension.
E.g.:
- Member A: Customer=A and Product=A
- Member B: Customer=B and Product=B
Multiselect on member A and B would not yield the expected result of (Cust=A and Prod=A) or (Cust=B and Prod=B).
Instead, it would result in (Cust=A or B) and (Prod=A or B), which means numbers for (Cust=A and Prod=B) as well as (Cust=B and Prod=A) would also be represented in the result.
Comments
Hi, I want to add a User dimension to the criteria bar, but without any members, and in order to share it I need to add a member
Idea is to create a switch so the user can select which chart should be displayed. User dimension has 2 empty members: Uitlevergraad % and Uitlevergraad 1 Dag %. When User selects the first then display chart0, when user selects the second then display chart1. (in reality it's same chart but with visibility agent display measure 1 or measure 2).
Hi Femke,
Maybe you can add a criteria from a dimension with very few members. For example, I got a Company dimension with just two members:
When I select all (both) members I will have a qualified criteria that does not filter my data - because I am asking to see data for all my Company members anyway.
This will satisfy the User Dimension requirement.
You might also consider taking a different approach to your overall goal. Here I am thinking of the possibility to use a Measure Selector: https://community.targit.com/hc/en-us/articles/360018904858-Measure-selector-basic-usage
BR / Ole
Thanks Ole, I take the second option, that is more like I indeed want it.
But can I disable the option "Select other..." for the users? I don't want them to be able to do this as It can mess up the analysis.
thanks
Note: In portal view it is disabled so that is very good, but if user has a client installation, what will he be able to do? Will only a designer (license) be able to change this or is is client installation related?
A Consumer user will not be able to "Select other...". And that is true for the Anywhere client, and also for the Windows client as long as the user logs on with Consumer rights only.
Thanks Ole
I have a question to verify a fact regarding user dimensions on criteria bar. When a normal dimension is used on criteria bar, the functionality is by default multi-select. Yet, when a user dimension is added, the functionality allows only for one member to be selected. Is there a way to add multiselect capability on a user dimension added on the criteria bar?
Hi Stratakos,
When you create the user dimension, you must enable 'Multiselect':
Furthermore, the members of the user dimension must use the same operator. I.e. you cannot have one member using the 'equal to' operator while the other members use the 'between' operator. Often, an 'equal to' operator can be changed to a 'between' operator. Example: Equal to 'This month' can be changed to Between 'This month' and 'This month'.
BR / Ole
Please sign in to leave a comment.