Manual

The report discussed here is designed to only return data from one call at a time. The user is
prompted to enter the RouterCallKey and the RouterCallKeyDay when launching the report.
All of the Unied ICME data originates from the Termination_Call_Detail table. This is a very
large table and the report must do a sequential scan to retrieve the data as the RouterCallKey
and the RouterCallKeyDay are not indexed columns. To minimize the effect on the HDS you
should run the report during off-hours, or run against an HDS that does not support concurrent
reporting users.
Table 13: CallGUID: F772B308-0808927
NumberApps
Visited
DNISANIRouter CallKeyRouter
CallKeyDay
End Date TimeStart DateTime
0830555893197893600003121591207/5/2006
2:30:23PM
7/5/2006
2:28:23PM
Table 14: CallGUID: F772B308-0808927
Answered Within
ServiceLevel
Agent Skill
TargetID
Service Skill
TargetID
CallTypeIDDateTimeTCD Record
NNoneNone50017/5/2006
2:39:23PM
1
N5002500150017/5/2006
2:30:23PM
2
Running Crystal Reports Templates
To run Crystal Reports templates, you must replace the ODBC connection with a local
connection. Do not install a reporting package on the Reporting Server. Select a machine that
is not used by Unied CVP to develop and launch reports.
Caution: These steps are only intended for advanced users. More complete documentation
is installed with the Crystal reporting product. If you are unfamiliar with how to set up
and congure ODBC connections, please refer to the Crystal Reports documentation.
To change a template's ODBC connection, perform the following steps:
1. Install Crystal Reports or a Crystal Viewer.
2. Install the Informix ODBC driver, which is included in the CSDK installer. The driver is
also available on the IBM web site.
3. Congure an ODBC connection to point to the Unied CVP Informix Server. Congure
a SQL Server connection to an HDS if required.
4. Open the template in Crystal Reports.
5. From the Database menu, choose Set Data Source Location.
6. In the Replace with window, perform the following steps to open a connection:
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
78
Chapter 6: - Reporting Against the Database
Using the Cisco-Provided Sample Report Templates