Hi Guys,
I created lookups and dashboards with lookups using an admin role. Now when other users (no admin role) are viewing the dashboards, all reports with lookups are not working. I made sure that the other users have permission to read the lookups (files, definitions and automatic lookups) but it's still not working.
The report will work when I add the "admin_all_objects" capability to those users. However, I cannot let all users to have admin rights to all objects. Is there any other way to fix this?
Thanks!