Cisco Cisco IP Contact Center Release 4.6.1 User Guide

Page of 138
 
Appendix A      Creating Sample Report Templates
Sample Real-Time Template
A-2
Template Design Guide Using InfoMaker for Cisco ICM/IPCC Enterprise & Hosted Editions, Release 7.0(0)
Sample Real-Time Template
This section provides instructions for creating a template that retrieves real-time 
data from the Admin Workstation database for several selected peripheral 
services. It employs a SQL statement with a single retrieval argument and presents 
the results as a 3D Pie Chart.
The completed template produces a report that looks similar to the following 
example.
For each service, this template shows two pieces of information from the tables in 
the Distributor Admin Workstation database: 
The box on the left shows the category, or subject of the report template. The 
category identifies the entities for which the template will retrieve data. In 
this example, the category is Enterprise Name (from the 
Service
 table).
Calls Offered (from the 
Service_Real_Time
 table) is the value displayed 
for each entity.
Category
Value