Manual

Unified CVP and Unified ICME Report................................................................................................77
Running Crystal Reports Templates....................................................................................................78
7. Reporting Best Practices..........................................................................................................................81
CPU Intensive Reports.............................................................................................................................81
Filtering Data to be Stored in the Database.............................................................................................82
ECC Variable Security..............................................................................................................................82
Writing Efficient SQL when Creating Reports..........................................................................................83
Database Sizing Issues............................................................................................................................83
Database Backup and Recovery..............................................................................................................84
Only Use Reporting Users when Querying the Database........................................................................84
Informix, Operating System Time, and Local Time...................................................................................84
Assuring Accurate Time Stamps for Reporting and Logging....................................................................84
Passwords................................................................................................................................................84
Joining Data with an ICM HDS Database.................................................................................................85
Joining Unified CVP and SQL Server Data..............................................................................................85
Reporting Isolation Level..........................................................................................................................85
Database Retention Settings....................................................................................................................85
Purge and Backup Database Maintenance Tasks....................................................................................85
Zero Duration Calls and Writing Reports..................................................................................................86
Index .............................................................................................................................................................87
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
iii