Need assistance on DrillDown view in reporting

shaik_irfan
Tera Guru

‎08-07-2018 01:23 AM

Hello,

 

We have a requirement where we want few of our ITIL users to have access to create there own reports and able to drilldown, change the Chart colors etc, for which we gave report_admin role with which user is able to select the chart color but not able to select the Drilldown view where user is getting Security Constraints not able to figure out which ACL is stopping. Can anyone please help me on this

 

find_real_file.png

Preview file
4 KB
0 Helpfuls
  • 2,286 Views
1 REPLY 1

Nia McCash
Mega Sage
Mega Sage

‎08-07-2018 08:33 AM

The Drilldown view references the sys_ui_view records so you would need to modify the ACLs for that table.

But don't confuse the Drilldown view

("Drilldown View: Select a view that determines how detailed records are shown when a specific part of the chart is clicked. This option is available for charts with drill-down capabilities. If you select a view that bears no relation to the table that the report is based on, the default view is used." from https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/reporting/c...) 

with a report drilldown.