Forum Discussion
User/Team Security Role Matrix (Counting Direct & Indirect Roles)
Hi all,
I may have a simple complex problem using the following model.
What I’m simply trying to achieve is a matrix where I count the security roles applied by user. So dimensions are Users & Security Roles. Calculation is a count of security roles. The tricky part seems to be that users can have security roles applied directly & indirectly (by security roles applied to teams they are part of).
1 Reply
Create a measure that adds both caclulations together, applying USERELATIONSHIP for each of the calculations.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with.
