Security Matrix - Custom Analytics

Summary

Sharing the Security Matrix Analytics which reports the mappings between roles

Content

Hello All,

I have seen lot of posts asking for a solution to generate the Security Matrix out of Fusion. However all of these threads were still open ended without any solution. The only solutions provided was to use the seeded "User and Role Access Audit Report" from Scheduled process area which would not satisfy most of the client's requirements as it generates one file for each role.

With this challenge, I took up this task to create a security matrix which lists all duty/bi/abstract/job roles in rows and all abstract/job roles as columns and map them using pivot table.. I have been successful in achieving this report so far.