Manual

–

Create New Connection, select ODBC

–

Select the Uniﬁed CVP connection that you conﬁgured in Step 3, and click Next.

–

Enter the password for the database, and click Finish

–

Drill down in to the database instance by selecting the instance name

(cvp_db__hostname), the database (cvp_data), and the database administrator

(cvp_dbadmin) tables

–

In the Current Data Source window, replace each table that is prefaced with a

t_with the corresponding table removing the t_

–

Click Update

–

Some reports have custom SQL. Custom SQL statements are named Command*;

use the Add Command entry under the database instance to update custom

statements. Right-click on the Current command, select View, and copy the SQL

query; then enter it in the New Command when prompted

–

Repeat the preceding steps for the HDS connection if required; with Uniﬁed ICME,

both the current and replace tables are prefaced with a t_

7. Refresh the report.

Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)

Chapter 6: Reporting Against the Database

Using the Cisco-Provided Sample Report Templates