Cisco Cisco IPCC Web Option User Guide

This section provides instructions for creating a sample historical report template for 
use with peripheral services. 

You will be creating a grid template that displays data for selected peripheral services. 
This template will use historical data from the ICM central database. The template’s 
SQL statement will use three retrieval arguments including (because it is a historical 
template) a start and end date. It will also include one computed field.

The completed template will produce a report that looks similar to the following 
example.

Tables

Select these tables for use in the template:

Service

Service_Real_Time

Table Columns

Select these table columns for use in the template:

Service.EnterpriseName

Service_Real_Time.CallsOfferedHalf

Retrieval Argument

Create a retrieval argument with these attributes:

Name: list_of_persvc
Type: Number array

Where Clause

Create a Where clause with these attributes:

Column: Service.SkillTargetID
Operator: IN
Value: (argument) :list_of_persvc

Layout:

In the Define Graph Data dialog box, set these attributes for the 
template:

Category Axis: Service_EnterpriseName

Values Axis: Service_Real_Time_CallsOfferedHalf

Title: Tasks Offered

Graph Type: 3D Pie Chart

Template File Name

Save the template as:

custom_realtime_tasks_offered