Lucent Technologies CentreVu Call Management System Custom Reports Manual

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-33
Step 6: Define 
the Maximum 
Graph Value
4
Enter an x in the Maximum Graph Value list to select either a fixed or 
variable maximum graph value. The maximum graph value is the value that 
the bar represents when the bar is at its maximum length or height (see 
Figure 4-9
). The value must always be a whole number or decimal.
If you select Fixed, you must also enter, in the accompanying field, the 
value the...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-34
Step 7: Define 
the First 
Threshold
4
Enter an x in the First threshold list to select a fixed threshold, 
variable threshold, or no threshold. The first threshold identifies the point at 
or above which the bar changes color — normally to indicate a caution 
condition (see Figure 4-9
). The first threshold should have the lower value of 
the two thresholds. The value must always be a whole number or...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-35
Step 9: Select 
Normal or 
Reversed 
Thresholds
4
Enter a y or n to select reversed threshold colors or normal threshold 
colors. n means the bar changes to a caution color at the first threshold and 
change to a warning color at the second threshold.
Enter y if you want to reverse the meanings of the thresholds. With 
meanings reversed, the bar is a normal color when it is above the second 
threshold. The...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-36
Step 10: Save 
the Bar 
Definition
4
To define additional bars, repeat steps 1 through 10.
Changing a 
Bar Definition
4
Select the Save action list option.®The Bar window disappears, 
and
 Successful appears in 
the Screen Painter status line 
to indicate the bar definition 
has been added.
NoteYou must assign a Row Search ID to the bar before your field 
definition is complete. When you do, the question...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-37
Defining the Rows of Data for a Report4
To complete the definition of a reports fields/bars, you must define the rows 
of the table(s) that supply data to the fields/bars. To do this, you must:
lUsing the Row Search window (Figure 4-11), define the criteria needed 
to find the appropriate rows of data. Each set of criteria is stored by row 
search ID.
lAssign the row search ID(s) to the...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-38
Figure 4-11:  The Row Search Window
Step 2: List the 
Report Input 
Var i ab le s
4
2a.Select the List inputs action 
list option to see the variable 
names previously defined on the 
Define Input window.®The List Inputs window 
appears.
2b.Print the windows contents via 
the   SLK and Print 
window option.
2c.Press   to return to the Row 
Search window.®
The List Inputs window 
disappears and...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-39
Step 3: Select 
a Row Search 
ID
4
Enter a number from 0 to 9 in the Row search ID field. The ID identifies 
the set (or one of the sets) of row search conditions you are using in the 
report. Thus, for a single report, you can use ten different sets of conditions 
to select rows of data.
You can create a new set of conditions from scratch or use Find one with 
the Next/Previous actions to view...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-40
The CentreVu CMS database table names are in the following tables.
Table 4-6:  Real-Time Table Names 
Name Data Stored
csplit Split/Skill data for the current interval.
psplit Split/Skill data for the previous interval.
cagent Agent data fro the current interval.
pagent Agent data for the previous interval.
ctkgrp Trunk group data for the current interval.
ptkgrp Trunk group data for the...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-41
See Appendix A, Database Items and Calculations
, for a description of 
these tables and the database items they contain.dtkgrp Trunk group data summarized by day.
wtkgrp Trunk group data summarized by week.
mtkgrp Trunk group data summarized by month.
htrunk Trunk data for intrahour interval.
dtrunk Trunk data summarized by day.
wtrunk Trunk data summarized by week.
mtrunk Trunk data summarized...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining the Rows of Data for a Report4-42
Step 5: Select 
Rows in the 
Table(s)
4
In the Select rows where: field, enter a selection criteria statement to 
tell 
CentreVu CMS how to select data from the table. The statement specifies 
value(s) for one or more database items or calculations.
Basic “Where” 
Clause
4
A basic clause has the following format:
Expression Relational Operator Value
The Expression can be a database item or...