Skip to main content

Hi,

 

I’m working on a board that uses complex security and I want to limit the items in the page selector. The security model is based on cost centres and employees, and others.

I want to display those employees in the page selector that match certain criteria (employee.criteria = true). For this, I have created a metric and used it as a dynamic variable (Technical Employees), then assigned it to the page selector.

Due to the security model, some users will have no access to given employees, and therefore the metric used for the variable will return nothing, which is correct.

However, in this situation, the board ignores the variable in the employee page selector, and incorrectly reverts to displaying all items to the user:

 

Suppose I don’t use the variable in the page selector, but manually select the employees that match my criteria in the Available items. In that case, the page selector will return an empty result if the user has no access to those employees, which is the expected behaviour:

 

 

Can you help me with this, please?

Thanks!

Hi there 👋🏼

 

Is your Technical Employees variable dimensioned by Users? If so, could you try applying the RESETACCESSRIGHTS function around the formula? The issue might be caused by inherited access rights from the Users dimension, which could be preventing users from reading the result of this variable.

Let me know if that helps or if you have any other questions!

Julie


Hi Julie,

No, that metric is not dimensioned by Users, but you gave me a great idea!

I set the block access right configuration to Public, and it eventually fixed the problem.

Thanks for your help!


Reply