Security Slowing Down Reports
Hi all - We have a security role, Global Reporting, that allows me to create, edit, run reports and see all data. We give this role out to our report developers but no other users.
We have other security roles that allow users to do various functions within Fusion, but only allows them to run reports and see the data they have access to in Fusion.
I have a report that takes 6.8m to run with my security role (Global Reporting). That same report increases to 1.5h when I run it with a user that has many security roles (17 total-HR Business Partner with access to each of our Business Units) to allow them to see the same data.