Lucent Technologies CentreVu Report Designer, User Manual

Page: 233 / 266

SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics
18-11
Calculation names
18
A calculation name is a name, as defined in the Dictionary subsystem,
that can substitute for the actual calculation. The calculation name can be
a standard name (used in standard reports) or a name you define. You
cannot append a table name to a calculation name. Therefore, you must
specify a table name in the
Table for calculations
field.
A calculation name normally reflects the purpose of the calculation. As a
result, entering a name is an easier, more meaningful way to define data
for a report field. More importantly, if you use a calculation name in many
custom reports and later decide to change the calculation, you can simply
make your changes once in the Dictionary subsystem.
CentreVu CMS
then applies those changes to every report that uses the calculation
name.
For example, if there are several different custom split reports, and in
each report, a field uses the standard calculation name
<PERCENT_ACD_TIME>. <PERCENT_ACD_TIME> represents the
calculation 100*((I_I_ACWTIME)/I_STAFFTIME). This
calculation, when assigned to the Intrahour Split table, finds the
percentage of time a split’s agents spent on ACD calls while logged in.
The calculation includes talk time (
I_ACDTIME
) and after-call-work time
(
I_ACWTIME
). If you no longer wish to include after-call-work time in the
calculation, then you can change the calculation in the Dictionary
subsystem such that <PERCENT_ACD_TIME> represents
100*(I_ACDTIME/I_STAFFTIME). Any custom report that uses the
calculation name PERCENT_ACD_TIME reflects the new calculation.
If you change the calculation for a standard calculation name, the change
affects any standard report, as well as any custom report, that uses that
calculation name.
You should not add table names to your custom calculations in the
Dictionary subsystem. Doing so makes the assigned calculation name
less flexible for use in custom reports. Also, if you append table names to
the Dictionary calculation and then also assign a table name to the
calculation name in the Field window, the report will fail.