Lucent Technologies CentreVu Call Management System Custom Reports Manual

  Introduction to CentreVu CMS Custom Reports CentreVu CMS Custom Reports
How CentreVu CMS Stores and Retrieves Data1-15
Figure 1-8:  Sample 2 of Database Item Selection
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...

  Introduction to CentreVu CMS Custom Reports CentreVu CMS Custom Reports
How CentreVu CMS Stores and Retrieves Data1-16
CentreVu CMS then finds the appropriate rows of data (see the boxed rows 
in Figure 1-9
).
Figure 1-9:  Sample 2 of Selection of Table Rows
where Rows
1, = SPLIT
07/02/93, = ROWDATE
from STARTTIME and
11:00am. to 08:00
1256
980
589
1340
1299
688
1001
809
445
1733
1303
899
1812
904
587 1
2
3
1
2
3
1
2
3
1
2
3 1
2
3
1
2
3
2
3
1
2
3
3 2 1 3
2 1 3 2 1
3 2 1ABNTIME
. . .
. . .
. . .. . .
....

  Introduction to CentreVu CMS Custom Reports CentreVu CMS Custom Reports
How CentreVu CMS Stores and Retrieves Data1-17
The data that 
CentreVu CMS plugs into the report is the data found in the 
intersection of the selected database items and columns. Thus, the report 
shows data as follows:
Figure 1-10:  Sample Custom Report 2
Defining data is the central task of creating and designing a custom report. 
However, you must do many other tasks to create a custom report. 
Chapter 2, Getting Started
,...

  Introduction to CentreVu CMS Custom Reports CentreVu CMS Custom Reports
How CentreVu CMS Stores and Retrieves Data1-18 

  Getting Started CentreVu CMS Custom Reports
General Information2-1
2 Getting Started
General Information2
This chapter tells you how to perform the following tasks in CentreVuä Call 
Management System (
CentreVu CMS):
lDefine a custom reports name, access, and type (the first task in 
designing a custom report)
lChange a custom reports access or description
lDelete a custom report.
You do these tasks via the Edit Report: Report Select window. 
To complete the design of a custom report, you must also...

  Getting Started CentreVu CMS Custom Reports
Defining a Reports Name, Access, and Type2-2
Defining a Reports Name, Access, and Type2
Use the steps in this section to define a new custom reports:
lName
lAccess
lType.
These are the first steps in designing a new custom report.
Step 1: Access 
the Report 
Select Window
2
Figure 2-1:  Custom Reports Main Menu
NoteIf you are a CentreVu CMS administrator, you can also specify the 
owner of the report you are defining (see 
Step 4: Define the User ID 
in this...

  Getting Started CentreVu CMS Custom Reports
Defining a Reports Name, Access, and Type2-3
Figure 2-2:  The Report Select Window
Step 2: Assign 
a Name to the 
Report
2
Enter a name for your report in the Report name field. The name can have 
up to 20 characters, including blanks. Because the name you give your 
report must be unique, you may want to look at existing custom report names 
before entering a name for your report.
Use the following steps to list existing report names.
2a.Clear the fields....

  Getting Started CentreVu CMS Custom Reports
Defining a Reports Name, Access, and Type2-4
Step 3: Enter a 
Report 
Description
2
If desired, enter a description of the report in the Description field. The 
description can have up to 50 characters, including blanks.2d.Check the list to ensure that the 
name you want to give your 
report has not already been 
used. If you are creating a 
global 
report, its name must be different 
from any name in the list. If you 
are creating a 
private report, its...

  Getting Started CentreVu CMS Custom Reports
Defining a Reports Name, Access, and Type2-5
Your description should be detailed enough to describe the reports contents 
accurately. 
Step 4: Define 
the User ID
2
Enter the user ID of the owner of the report. The default is your user ID. If you 
are a 
CentreVu CMS administrator, you can enter another users ID if you 
wish to create a custom report for that user. This might be the case if you 
want only that user to be able to run the report.
Step 5: Define...

  Getting Started CentreVu CMS Custom Reports
Defining a Reports Name, Access, and Type2-6
If you select global, your reports name must be different from the name of 
any other custom report — global or private.
Private access to the report means that only you (and the 
CentreVuCMS 
administrator(s)) can run the report. In addition, no other users, except for 
CentreVu CMS administrators, can copy or run the report design for use in 
their own custom reports.
If you select private, your reports name must...