Database view in performance analytics

prasad48
Tera Guru

‎06-27-2017 03:15 PM

Hi,

I created view for task and task_sla   and my requirement is show breached tickets count by break down   based on assignment group.

I have added   database view in the indicator and added breakdown as group table   and assignment group column

Here issue is i am not able to filter by assignment group.Please help?

find_real_file.png

Preview file
60 KB
0 Helpfuls
  • 1,848 Views
5 REPLIES 5

sachin_namjoshi
Kilo Patron
Kilo Patron

‎06-27-2017 03:21 PM

What's breakdown source configuration?


Please make sure that "Sys ID" is used as in source.



find_real_file.png




Regards,


Sachin


Preview file
29 KB
0 Helpfuls

prasad48
Tera Guru

‎06-27-2017 03:48 PM

When am using table as indicator source   and breakdown source it is working fine.


But when i use databaseview as indicator source and breakdown source , then it is not working. Is it correct to you database view?


0 Helpfuls

sachin_namjoshi
Kilo Patron
Kilo Patron
In response to prasad48

‎06-27-2017 03:53 PM

You need to create a read ACL for your users on the tables in a view to generate reports on database views. Non-admin users do not have access to database view records unless a read ACL on the database view record allows access.



Regards,


Sachin


0 Helpfuls

Mubashira
Tera Contributor
In response to prasad48

‎06-29-2022 09:06 AM

Hi,

I am getting the same issue. Please let me know if anyone has solution for this issue.

0 Helpfuls