Cisco Cisco Customer Voice Portal 8.0(1)

Reporting Isolation Level

Reporting clients should never run with an isolation level of repeatable read as this could hold
locks and prevent updates to the data.

Informix, Operating System Time, and Local Time

Informix only displays a datetime that corresponds to the same time zone as the Informix server
operating system's time zone. As a result, two items must be kept in mind:

•

If you wish a datetime to be displayed for a time zone other than that of the Informix server
operating system, you must use reporting tools or SQL tools (for example, those available
with Crystal Reports or Java) to do this.

•

If, in your system, you are using more than one Informix server for Unified CVP reporting,
it is best if all such server OSs are set to the same time zone. This helps avoid confusion.

Assuring Accurate Time Stamps for Reporting and Logging

Unified CVP components do not themselves synchronize machine times. However, customers
must provide a cross-component time synchronization mechanism, such as NTP, to ensure
accurate time stamps for reporting and logging.

Joining Data with an ICM HDS Database

Joining Unified CVP and Unified ICME data can be a very expensive operation on the Unified
ICME system. To minimize performance impacts on an HDS system, use one of the following
strategies:

•

Dedicate an HDS for these reports

•

Query an HDS when Unified ICME reporting users are not running reports

Joining Unified CVP and SQL Server Data

To join data from a SQL Server Database and an Informix Database one must use a reporting
tool that supports the ability to join data from two heterogeneous databases.

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