Help Desk 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:

  1. Click Navigator > Tools > Reports and Analytics.

  2. Click Browse Catalog.

    The Oracle Business Intelligence Catalog page is displayed.

  3. In the Folders pane, click Shared Folders > Service > Subject Area Contents > Saved Queries - OTBI HR HelpDesk - New or Saved Queries - OTBI Internal HelpDesk.

Here's a table that provides details about the available saved queries:

Analyses Name

Description

Job Role

Location

Top Five Queues by Unassigned SRs

Saved query to retrieve the top five queues with unassigned SRs

  • Next Gen Human Resource Help Desk Administrator

  • Next Gen Human Resource Help Desk Manager

  • Next Gen Human Resource Help Desk Agent

  • Next Gen Human Resource Help Desk User

Shared Folders > Service > Subject Area Contents > Saved Queries - OTBI HR Help Desk - New

Top Five Queues by Unassigned SRs

Saved query to retrieve the top five queues with unassigned SRs

  • Internal Help Desk Manager

  • Internal Help Desk Agent

  • Internal Help Desk User

  • Internal Help Desk Administrator

Shared Folders > Service > Subject Area Contents > Saved Queries - OTBI Internal Help Desk