input controls and roles

[daniel_17]

I'm creating dashboards for multiple people within my company.

Some of them should have access to all of the data, some should have access to regional data (with the option to see it by city in the region) and some should have access only to a single city.

 

Do I have to create a different dashboard with different reports in them for each one of them or is there a way to set limits to the input selection withing the dashboard builder??

 

Thanks

Daniel

[mlaspina]

Try using the $X on the input control query. 

For example : where $X{IN,DatabaseRoleColumn,$P{LoggedInUserRoles}}

This would translate to "Where DatabaseRoleColumn In ('Role_user', 'Role_admin')" for users with those 2 roles.