Lucent Technologies CentreVu Call Management System Custom Reports Manual

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-11
Step 3: Add 
Data to the 
Ta b l e
6
To help you add data to the table, you must first create a data entry form 
associated with your table. For more information about forms, see “Creating 
Your Own Forms” in the 
INFORMIX-SQL Relational Database Management 
System User Guide
. For more information about adding data, see “Entering 
Data,” in the same document.
3a.On the Main Menu, select FORM.®
The FORM menu appears....

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-12
3d.Enter the name of the table you 
want to enter data for, and press 
.®The Table-selection-
complete
 menu appears.
Return
GENERATE FORM: Table-selection-complete Select-more-tables Exit
Continue creating a default form with the selected tables.
----------------- cms ----------------- Press CTRL-W for Help --------
3e.Select Table-selection-
complete.®The screen form 
specification was 
successfully compiled 
appears...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-13
3h.Select Add.®
The cursor moves to the first 
column in the table.
3i.Enter data for the first column of the 
table, and press the   key. ®The cursor moves to the 
next column.
NoteIf you get an error message, you may have entered data in the wrong 
format.
3j.Repeat Step 3i for each column.
3k.Press the   key to save the row 
of data. ®Row added 
appears. The 
row of data has been added 
to the table and saved....

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-14
Modifying a 
Ta b l e
6
Use the following steps to add, change, or delete columns in an existing 
table.
Adding a 
Column
6
Changing a 
Column
6
Deleting a 
Column
6
1.On the INFORMIX Main Menu, 
select Table.®The Select Database 
screen appears.
2.Press the   key.®The TABLE menu appears.
3.Select Alter.®The ALTER TABLE screen 
appears. A list of existing 
tables also appears.
4.Enter the name of the table you 
want to...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-15
2.Select YES to remove the column.®
The column disappears, and 
the ALTER TABLE menu 
appears.
3.At the ALTER TABLE menu, 
select Exit when you are finished 
changing the table.®The Build-new-table menu 
appears.
4.Select Build-new-table to 
save your changes. Select 
Discard-new-table to ignore 
your changes.
NoteIf you change columns in a table, then you may have to rebuild the 
form assigned to the table. 

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-16
Changing Data 
in a Table
6
Use the following steps to add, change, or delete data in an existing table.
Adding Rows of 
Data to a Table
6
1.On the INFORMIX Main Menu, 
select Form.®The FORM menu appears.
2.Select Run.®The RUN FORM screen and 
a list of forms appear.
3.Enter the name of a form, and press 
. ®The PERFORM menu 
appears.
Return
1.Select Add to add rows of data.®The tables column fields 
appear with the...

  Advanced Report Design CentreVu CMS Custom Reports
Creating a Custom Data Table6-17
Changing Rows 
of Data in a 
Ta b l e
6
Deleting Rows 
of Data From a 
Ta b l e
6
1.To change data in a row, display the 
data you want to change. 
To do this, select Query.®The tables column fields 
appear, with the cursor 
resting in the first field.
2.Enter data in a column you want to 
search on, and press  .®The column fields fill with 
data for that row.
3.Select Update, and press the 
 key.®The Update screen...

  Advanced Report Design CentreVu CMS Custom Reports
Including Forecast Data in a Custom Report6-18
Including Forecast Data in a Custom Report6
For historical custom reports only, you can design reports that include 
current day forecast data. Only current day forecast data is available for 
custom reports because it is the only forecast data saved in the 
CentreVuCMS database.
The steps for creating a custom report with forecast data are almost identical 
to the steps for creating any other custom...

  Advanced Report Design CentreVu CMS Custom Reports
Including Forecast Data in a Custom Report6-19
Figure 6-1:  Sample Forecast Report Design
In the report in Figure 6-1
, Row Search ID 0 is assigned to the Time, 
Forecast Calls Carried, and Number Agent Req’d fields. The 
conditions for Row Search ID 0 might be as follows:
Figure 6-2:  Row Search Conditions for Forecast Data — Sample 1
 
04/19/95 00:30 AM CentreVu(TM) CMS Windows: 2 of 5 ^ 
Custom Reports: Screen Painter: split status: Hist
Add...

  Advanced Report Design CentreVu CMS Custom Reports
Including Forecast Data in a Custom Report6-20
Notice that, as in historical interval reports for splits, the statement in Row 
Search ID 0 searches for rows based on values for STARTTIME, 
ROW_DATE, and SPLIT.
In the report in Figure 6-1
, Row Search ID 1 is assigned to the Forecast 
Method field. Notice also that the database item for this field is FMETHOD. 
FMETHOD is stored in the f_cday table, but is not stored in the 
f_cdayrep table. This is an...