Database view in performance analytics

[prasad48]

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?

[sachin_namjoshi]

What's breakdown source configuration?

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

Regards,

Sachin

[prasad48]

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?

[sachin_namjoshi]

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

[Mubashira]

Hi,

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