Service Analytics Saved Queries
Saved queries are canned analyses that enable you to construct reports efficiently. The saved queries are pre-calculated data filters that can be conveniently applied on any analyses that you want to build. They're also useful in cross-subject-area reporting.
Here's how you access the saved queries:
-
Click Navigator > Tools > Reports and Analytics.
-
Click Browse Catalog.
The Oracle Business Intelligence Catalog page is displayed.
-
In the Folders pane, click Shared Folders > Service > Subject Area Contents > Saved Queries - OTBI.
Here's a table that provides details about the available saved queries:
Analyses Name |
Description |
Job Role |
---|---|---|
SRs assigned to me |
Saved query to retrieve the list of SRs assigned to the signed in user. Apply this on the Service Request ID column when used in analyses. |
|
SRs where I am on the team |
Saved query to retrieve the list of SRs where the signed in user is part of the SR team. Apply this on the Service Request ID column when used in analyses. |
|
SRs assigned to me or my subordinates |
Saved query to retrieve the list of SRs assigned to the signed in user or the user's subordinates. Apply this on the Service Request ID column when used in analyses. |
|
SRs where I am or my subordinates are on the team |
Saved query to retrieve the list of SRs where the signed in user or the user's subordinates are part of the SR team. Apply this on the Service Request ID column when used in analyses. |
|
Queues where I am a resource |
Saved query to retrieve the list of queues where the signed in user is a resource. Apply this on the Queue ID column when used in analyses. |
|
Queues where I am or my subordinates are resources |
Saved query to retrieve the list of queues where the signed in user or the user's subordinates are resources. Apply this on the Queue ID column when used in analyses. |
|