The CreatorCon Call for Content is officially open! Get started here.

Cannot configure filter to follow other filters as report admin

Pam Reid1
Kilo Sage

Is there a way to be able to configure filters to follow each other such as Manager -> Assignment Group -> Assigned To without being a system administrator?  We have a separate reporting team that manages all reporting and analytics and they are not system administrators.  Is there some access or role (beside admin) that can be given, that would allow them to be able to configure the filters?  Cascading filters in the previous versions worked fine, but now they have to contact a system admin to flip the switch which is a waste of everyone's time.

1 ACCEPTED SOLUTION

I have some more specific information. You need an admin to create an ACL granting read permission to report_admin for the tables sys_m2m and sys_collection.

We have created PRB1841407 to add this read permission by default for at least report_admin and at least for Zurich. Suggestions of other roles welcome.

View solution in original post

7 REPLIES 7

jeffrubinoff
ServiceNow Employee
ServiceNow Employee

The system admin role is necessary only for many-to-many filters. If you are creating one-to-many filters, the same roles apply as for non-cascading filters: In the dashboard in-line editor, dashboard_admin or editing rights to the dashboard. In the Filter Designer (Platform Analytics > Library > Filters > New), analytics_filter_admin.

Yes i understand that.  So when i create for instance the manager -> assignment group filter, anyone can create that on their own and see the filter follow.  But for doing something like assignment group - assigned to you cannot.. What we are trying to solve is, what role or what possible changes would need to be made so that a report admin or dashboard admin, etc could do these relationships?  Is there an ACL somewhere on a table?  or is there something else only allowing admin to do it?  I checked the sys_m2m table but none of these relations are even in that table.  Any idea on what is actually causing it to not allow?

I'm afraid that I don't know the answer to that, but if you can wait until 4 January, enough of our developers will be back that I can try to get you an answer.

That would be fabulous, thank you.