Cisco Cisco IP Contact Center Release 4.6.1 Technical References
A-2
Template Design Guide Using InfoMaker for Cisco Unified ICM/Contact Center Enterprise & Hosted Editions, Release 8.0(1)
Appendix A Creating Sample Report Templates
Sample Real-Time Template
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.
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:
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
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.
Specifications for the Sample Real-Time Template
Category
Value
Table 0-1
Sample Real-time Template Specifications
Component
Description
Set as Working Library
icm\<icm_instance_name>\aw\custom\persvc\ppb
050.pbl
050.pbl
Presentation Style
Graph
Tables
•
Service
•
Service_Real_Tim
e
Table Columns
•
Service.EnterpriseName
•
Service_Real_Time.CallsOfferedHalf