Lucent Technologies Centrevu Report Designer Version 8 User Guide

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Retrieves Data17-9
Next, you must identify the appropriate rows that supply data. You might 
want data for the following:
lSplit 1, which means you must identify rows that have the value 1 for 
the SPLIT 
database item.
lThe date 07/02/93, which means you must identify rows with the 
value 070293 for the ROWDATE 
database item.
lThe intrahour intervals 8:00 a.m. to 11:00 a.m., which means you...

  How CentreVu® CMS Stores and Retrieves Data CentreVu Report Designer Version 8 User Guide
How CentreVu CMS Retrieves Data17-10
CentreVu CMS then finds the appropriate rows of data (see the boxed 
rows in the following figure).
The data that 
CentreVu CMS reports is the data found in the intersection 
of the selected database items and columns. Thus, the report shows data 
as follows:
Defining data is the central task of creating and designing a report. 
However, you must do many other tasks to create a...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Introduction18-1
18  SQL Query and CMS Database Table 
Basics
Introduction18
The Call Management System (CMS) is a relational database that is made of 
a series of database tables. The tables are made up of rows of database 
items and columns of data. CMS reports retrieve data from the database 
tables and format the data into readable tables, charts, and fields.
Reports use Structured Query Language (SQL) queries to...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
About SQL Queries18-2
About SQL Queries18
Reports use SQL queries to retrieve specific data from the database 
tables. You can create and edit queries using the Edit | Queries feature of 
the Report Designer. This section gives you information about SQL 
queries, concentrating on the use of WHERE clauses. For extensive 
information on SQL, please refer to your 
INFORMIX documentation.
SQL queries use WHERE clauses to...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
About SQL Queries18-3
When you run the report, CentreVu®  CMS finds the row in the table (see 
the following figure) for Split 5 and fills in the report fields with data from 
that row (in bold in the figure).
Thus, the report fields show the following data:
Split: 5
ACD Calls: 451
Average Talk Time: 61 (the result of 27635/451
)
This example of row search criteria would also include the selection of an 
ACD. See...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
About SQL Queries18-4
Multiple WHERE 
Clauses
18
To put two or more clauses in a statement, use and 
or or
. Use and 
to 
define two or more clauses where 
CentreVu CMS finds only rows that 
meet all conditions. For example, the following statement searches for 
rows where splits had an average speed of answer greater than 30 
seconds and abandons greater than 100.
Select rows where: ANSTIME/ACDCALLS > 30 and ABANDONS...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
About SQL Queries18-5
WHERE Clause 
for Excluding 
Rows of Data
18
If you want to exclude Split 5 from the report, but include all other splits, 
you might enter a WHERE clause as follows:
Select rows where: SPLIT != 5
or
Select rows where: SPLIT  5 

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics18-6
CMS Database Table Basics18
The CMS database is a relational database that consists of a series of 
database tables. The tables are made up of rows of database items and 
columns of data. CMS reports retrieve data from the database tables and 
formats the data into readable tables, charts, and fields.
This section teaches you about CMS database items and calculations, 
which are names...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics18-7
Name Data Stored
hsplit Split/Skill data for each intrahour interval.
dsplit Split/Skill data summarized by day.
wsplit Split/Skill data summarized by week.
msplit Split/Skill data summarized by month.
hagent Agent data for each intrahour interval.
dagent Agent data summarized by day.
wagent Agent data summarized by week.
magent Agent data summarized by month
htkgrp Trunk group data for...

  SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics18-8
Database Items18A database item is the name of a column of data in a table, either 
standard or custom. When you enter a database item, you must always 
add the name of a table and a period (.) as a prefix if more than on table 
is included in the query. The format is ..
Examples:
dsplit.ACDCALLS
hagent.STARTTIME
ctkgrp.NUMINUSE
Standard Database 
Items
18
Standard database items are...