Cisco Cisco Unified Customer Voice Portal 11.0(1)

Unified CVP VXML Element By Call Report

Customers who deploy self-service applications need a report that tracks a call's path through
VXML elements. This report is used to debug and monitor VXML applications after they are
deployed.

Subdialog Start

1:11:53 am

1:11:53 am

Subdialog Start 01

Start

1:11:53 am

1:11:53 am

start

ReqICMLabel

1:11:54 am

1:11:53 am

ReqICMLabel

ElementFlag

1:11:54 am

1:11:54 am

Flag Done

Voice

1:11:54 am

1:11:54 am

Audio Exit

Voice

1:11:54 am

1:11:54 am

Audio ValidLabel

Subdialog Return

1:11:54 am

1:11:54 am

Subdialog Return 01

End

1:12:43 am

1:12:43 am

end

Unified CVP and Unified ICME Report

Customers who deploy self-service applications with their Unified ICME or Unified CCE system
need a report that will track the details of this system as well as Unified CVP details. Crystal
Reports can join data from more than one ODBC connection. In particular, Crystal Reports
functionality allows you to select two data sources (in this case, one from Unified CVP Informix
tables and one from Microsoft SQL Server tables) and create a join report.

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 Unified 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.

0

8305558931

9789360000

312

159120

7/5/2006
2:30:23PM

7/5/2006
2:28:23PM

Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(2)