User dimensions on Criteria Bar

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:

mceclip0.png

This feature is great value, especially when working with User dimensions with custom Dynamic criteria:

mceclip1.png

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 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.
Was this article helpful?
0 out of 0 found this helpful

Comments

8 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).

    0
  • Thanks Ole

    0
  • 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

    0
  • 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.

    0
  • 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?

    0
  • 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

     

    0
  • 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

    0
  • 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?

    0

Please sign in to leave a comment.