DCA by User´s role

Hi,

I am trying to create a module with the ff details :

Dimension :

List : Users

Line item : Roles ( format is list - roles)

Is there a way to create a formula for the Line item so it will pick up the role in the User setting?

Thanks!

Hello,

I wish to create a dashboard where I could show the user - the roles of all the users and if they wish to change the user role they can update it from the dashboard, how can we do that? (I need an understanding how to display the user role of users on the dashboard)

As deleting a user from a dashboard is not feasible so changing the role to No access might help with Model Security.

 

Thanks.