Cisco Cisco Unified Customer Voice Portal 11.0(1)

Page of 102
VXMLError Table..................................................................................................................................77
VXMLHotEvent Table...........................................................................................................................77
VXMLHotLink Table.............................................................................................................................78
VXMLSession Table.............................................................................................................................78
VXMLSessionVariable Table................................................................................................................79
VXMLVoiceInteractDetail Table............................................................................................................80
CPU Intensive Reports.............................................................................................................................87
Filtering Data to be Stored in the Database.............................................................................................88
ECC Variable Security..............................................................................................................................88
Writing Efficient SQL when Creating Reports..........................................................................................89
Database Sizing Issues............................................................................................................................89
Database Backup and Recovery..............................................................................................................90
Only Use Reporting Users when Querying the Database........................................................................90
Informix, Operating System Time, and Local Time...................................................................................90
Assuring Accurate Time Stamps for Reporting and Logging....................................................................90
Passwords................................................................................................................................................90
Joining Data with an ICM HDS Database.................................................................................................91
Joining Unified CVP and SQL Server Data..............................................................................................91
Reporting Isolation Level..........................................................................................................................91
Database Retention Settings....................................................................................................................91
Purge and Backup Database Maintenance Tasks....................................................................................91
Zero Duration Calls and Writing Reports..................................................................................................92
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.0(1)
iii