Cisco Cisco IP Contact Center Release 4.6.1 User Guide
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.
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.
example.
For each service, this template shows two pieces of information from the tables in
the Distributor Admin Workstation database:
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
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