Criteria-based dynamic content should react to forced criterias from roles
Criteria-based dynamic content should react to the forced criterias set on the visiting user.
Example: You set forced criterias on department in cube A for all your roles, because you want all dashboards on cube A to show only the data for the given department the user is from. To make this very clear for your users when entering the dashboard, you add some criteria-based dynamic content to the dashboard title. In this scenario the dynamic content shows nothing or the custom "no criteria"-text, because dynamic content doesn't work with forced criterias.
Currently we're forced to make the user drill down into an object or choose from a slicer or the criteria bar, but this is another click for the user, which often has a negative impact on user adoption and implementation of our dashboards.
Therefore I request criteria-based dynamic content should react to forced criterias.
Comments
Hi Alexander,
If you use the Dynamic content option "Members" instead of "Criteria", I think you should be able to show the correct department - also when it has been set from Forced criteria.
BR / Ole
Hey Ole
Thanks for replying. You're correct that would fix it.
The problem is, that we need our roles to have forced criterias on different levels of a organization hierarchy dimension - i.e. one role needs a forced criteria on level 2 of the hierarchy, another role needs a forced criteria on level 3 etc. Member-based dynamic content cant handle this, as it requires you to pick a specific level in the hierarchy to show.
If I set the member-based dynamic content to show level 3 of the hierarchy, all the roles which have forced criterias set on level 2, will see a looong line of organizational units of alle the different units on level 3.
I hope this description makes sense.
I presume it's quite common practice to set forced criterias on organizational hierarchies, and that you need to set criterias on different levels of the hierarchy.
I have found a way stacking a lot of "hiding" column chart titles with member-based dynamic content for each level in hierarchy (that hide if they are not unique on their level) stacked on top of each other, on top of a criteria based textbox but it is a lot of work just to have the correct organisation title displayed on a dashboard for every type of manager.
Hi Alex,
Potentially you may also enable the "Single" range setting on the Members dynamic content option - to show nothing when multiple members apply.
In your example, users with forced criteria on level 2 will then see nothing on level 3 - and vice versa.
Of course, this will only work if your forced criteria is set by a single member as well.
BR / Ole
Please sign in to leave a comment.