Lucent Technologies Centrevu Report Designer Version 8 User Guide

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Real-Time Report Error Codes16-13
12 Description: 
Memory allocation error.
Solution: Check the error logs.
13 Description: Query cannot select more than one table.
Solution: Check the error logs. Error Description/Solution 

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Real-Time Report Error Codes16-14 

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
Introduction17-1
17  How CentreVu® CMS Stores and 
Retrieves Data
Introduction17
The most important and difficult part of designing a report is defining the data 
that goes in the report. To define report data, you must first understand how 
CentreVu®  Call Management System (CMS) stores and retrieves data. 
This chapter provides the following 
CentreVu CMS information:
lStandard CentreVu CMS reports that cannot...

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Stores Data17-2
How CentreVu CMS Stores Data17
CentreVu CMS stores data in the CentreVu CMS database. The 
database is divided into 52 different tables. A table is an array of columns 
and rows that stores data for a type of ACD element (split/skill, agent, 
trunk, trunk group, VDN, vector, call work code, forecasting, agent trace, 
call records, or exceptions) and for a specific time frame (for...

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Stores Data17-3
The following figure shows how a small piece of the Historical Intrahour 
Interval Split table looks.
The example above shows data from July 1 to July 3, 1993, and 
simulates data for an ACD that has only three splits, 60-minute intrahour 
intervals, and activity each day from 8:00 a.m. to 12:00 p.m. only.
The 
CentreVu CMS database uses names to refer to columns of data in a...

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Stores Data17-4
Each row in a table contains data that is related by the value(s) of one or 
more of the columns. For example, each row in the Current Interval 
Agent table contains data related by agent login ID. If you look at the row 
for login ID 1006 (displayed in bold), you see that the agent is logged into 
Split 1 on extension 5671 and is currently in AUX work mode. In addition, 
up to...

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Retrieves Data17-5
How CentreVu CMS Retrieves Data17
CentreVu  CMS retrieves data from the database based on three types of 
information you supply when you design a report:
lThe name of the table
lThe database items in the table
lThe rows of data in the table.
To tell 
CentreVu CMS how to retrieve data, you must tell CentreVu CMS 
to access the appropriate database table. Then, for each report...

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Retrieves Data17-6
Next, you identify the appropriate rows that supply data. If you want 
agents in Split 1, you must tell 
CentreVu CMS to find rows that have the 
value 1 for the SPLIT 
database item. When you run the report, 
CentreVuCMS finds the appropriate rows of data in the cagent 
table 
(see rows with arrows in the following figure).
. . .. . .. . .
. . .. . .. . .
. . .. . .. . .
. . .....

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Retrieves Data17-7
The data that 
CentreVu CMS reports is the data found in the intersection 
of the selected database items and rows. Therefore, the report shows 
data as shown in the following figure:
203
789
549
402
452
616
569
745
109
367
322
188
704
256
980
589
340
299
688
901 851
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
....

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Retrieves Data17-8
Actually, when you design a report, you normally set up the row selection 
so that the users running the report can choose the rows in the reports 
input window. For example, to run the report in the above figure, you 
would set up the row selection so users would fill out a Report Input 
window that asked them for a Split number.
As mentioned earlier, 
CentreVu CMS uses indexes...