Importing a Ccmm user-created report | Avaya NN44400-710 manual

Contact Center Multimedia reports

13From each of the left and right Fields lists, click a field to include.

Attention: The selected field on the right Fields list must contain the same data as the selected field on the left Fields list.

14From the Join list, select a join type.

15Click link.

16Click Next.

17In the Fields list, double-click a formula or field to add to the report.

18Use the up and down arrows to change the order of the selected fields.

19Click the configuration icon.

20In the report layout section, select Portrait or Landscape.

21On the toolbar, click the Save Report icon.

22Select the folder in which to save the report.

23In the report Name box, type the name of the report.

24Click Save.

--End--

Importing a CCMM user-created report

Import a Contact Center Multimedia report into Crystal to customize the report layout and to add and delete database tables and database fields.

The following is a list of items and features that you cannot edit, delete, or add to a report:

•Connections

•Formulas

•Record selection formulas

•Subreports or command tables

Prerequisites

•Install Report Creation Wizard.

Procedure steps

Step Action

1On the Report Creation Wizard tool bar, click the Import to Historical Reporting icon.

2In the Report Title box, type the <report name >.

70 NN44400-710 Contact Center Performance Management

12 November 2010

Image 70

Avaya NN44400-710 manual Importing a Ccmm user-created report, Contact Center Multimedia reports

Contents

Performance Management Copyright 2010 Avaya Inc All Rights Reserved Contents Contents NN44400-710 Contact Center Performance Management November Contact Center Multimedia reports Statistics configuration 115 Navigation FeaturesNew in this release Other changesPage Introduction PrerequisitesPage Performance management fundamentals Filters Real-time statistics ThresholdsHistorical statistics Performance management fundamentals Access and partition management Crystal ReportsPage Prerequisites to filter management Filter managementCreating a filter in Real-time Reporting Filter management Creating a filter in Historical reportingAdding skillset elements to a filter End Adding application elements to a filter Step Action Adding agent elements to a filter Agents that match your criteria appear in a table Removing elements from a filter Deleting a filter Applying filters to real-time displays Removing filters from a real-time display Select the Private Tabular Displays folder Filter management Prerequisites to real-time reports Real-time ReportingLogging on to Real-Time Reporting Real-time Reporting Creating a private real-time displaySelect the Public Tabular Displays folder Making a public copy of a private real-time display Applying custom formulas to real-time displays Deleting public displaysClick Add Field Step Action Log on to Real-Time Reporting Printing a summary chartStarting a network summary Click Network Summary Printing a real-time display Deleting a private display Viewing the non-staffed skillsets Deleting an exported real-time display gridFrom the Displays menu, click Manage Exported Displays Page Exported displays Exporting summary chartsPrerequisites to exported displays Exported displays Exporting network summary chartsClick Export JPG Viewing an exported real-time display Exporting real-time display grids Changing the path to export a summary chart Printing a real-time display grid Page Graphical displays Prerequisites to graphical display management Adding a graphical display Graphical displays Deleting a graphical display Opening a graphical displayGraphical displays End Making a public copy of a graphical display Assigning threshold alerts to a nodal real-time display Click Submit to save your changes Configuring an agent map Adding agents to an agent map Arranging agents in an agent map using drag and drop Arranging agents in an agent map automatically Changing the header format of icons in an agent map Customizing the agent map layoutResizing an agent map Click Save Layout End Zooming in or out on an agent map display Activate a display from an agent map Activate an agent details window from an agent map Configuring a billboard display Presentation area, select Billboard Configuring a chart display Graphical displays Creating a private collection Presentation area, select Private Collection Presentation area, select Private Billboard Collection Creating a private billboard collectionCreating a public collection or public billboard collection Action Arranging the billboards in a billboard collection Real-time report customization Prerequisites to real-time reporting customization Real-time report customization Adding charts to the Real-time DashboardCreating a Real-time Dashboard display From Presentation, select Dashboard Changing chart properties in the Real-time Dashboard display Saving the real-time display Customizing display properties Adding a new column to a real-time displayClick the Private Tabular Displays folder Changing the refresh rate of a real-time display Changing the font size in a real-time display grid Changing the chart type for a site summary Changing the color settings of a real-time display grid Changing the fill color of a summary chart Changing column names Changing the column width in a real-time display Changing the data collection mode of a real-time display Rearranging columns in a real-time display Changing the title of a real-time display grid Deleting columns from a real-time display Moving the chart contents within the window Rotating a summary chart Increasing or decreasing the summary chart size Zooming in on areas of a summary chart Prerequisites Creating a Ccmm report template for user-created reports Contact Center Multimedia reportsPrerequisites to Ccmm reports DSNs Available list, click Ccmm DSN Importing a Ccmm user-created report Contact Center Multimedia reports Select a Report Mode Page Historical Reporting Prerequisites to Historical Reporting Applying filters to network consolidated historical reports Logging on to Historical ReportingHistorical Reporting Click the Public Report Templates folder Defining the selection criteriaClick the Selection Criteria heading Prerequisites Opening a public, private, or shared report Running an Ad hoc report Report Details Selection Criteria Data Range Schedule Running a parameter report Ad hoc Historical Reporting End Exporting an Ad hoc report Creating a shared or private report Schedule Click Report Details Defining the report output Historical Reporting Importing a report Click Activate Importing a parameter report Editing a report Printing an ad hoc report Click Save Report End Scheduling a report Prerequisites Historical Reporting Printing a report schedule Variable Definition Activating a scheduled report Deactivating a scheduled report Click De-Activate End Adding the euro symbol to a custom report Step Action Open Microsoft Word Running a report from a different time zone Deleting a report Deactivate the schedule. See Deactivating a scheduled report Expert reports Expert reports Defining a connection to the serverDefining the Sybase DSN Select Server Object, Add Select Sybase ASE Odbc Driver Installing the Caché Odbc driver CcmsClick Test Connect Page Select Intersystems Odbc Installing the Caché Jdbc DriverDefining the Caché Odbc DSN Ccms Cache Namespace, enter Ccmsstat Running the Database View Definition report Installing the Caché Odbc driver CcmmComponents\Cache\lib\ Defining the DSN Ccmm Select the CCMM\CacheODBCSoftware folder Creating a report and connecting to the database Crystal Expand Current Connection, Obdc entry, blue, dbo, Views Changing a database alias Variable Value Creating reports using Microsoft Excel Setting the page orientationChoose Data, Import External Data, New Database Query Creating reports using Microsoft Access Query Wizard-Filter Data box, click Next Expert reports Select the Preview the report option Saving a report template in Crystal ReportsSelect File, Save As Importing a user-created Crystal Report Linking subreport Timestamp fields Adding customized formulas to a report Crystal Click User Editor End Creating a custom report Choose Report, Expert Statistics configuration Prerequisites to statistics configuration Statistics configuration Creating custom formulas Variable definitions From the Variables list, select CallsAnswdAftThreshold Statistics configuration Variable DefinitionFrom the Statistics Group list, select Application From the Variables list, select CallsAnswered Modifying custom formulas Deleting a custom formula Configuring historical statistics data collection Select the Historical Statistics folder Configuring historical statistics collection on the NCC Click the Network Historical Statistics folder Application Statistics Optional IVR Statistics Optional Configuring real-time statistics collectionAgent Statistics Optional Statistics configuration Page Report Creation Wizard Creating a simplified report Starting Report Creation WizardOpening an existing report Report Creation Wizard Prerequisites Skillset Timestamp AgentLogin Creating a sample Agent by Skillset Performance report From the iAgentBySkillsetStat, select CallsAnswered Selected field WidthSkillset Report Footer Group Footer #1 Group Footer #2 Group Footer #1 section, click @RCWTalkTime Group Footer #2 field Width Report Creation Wizard Report Footer field Width Group Header #1 section, click Skillset Header field Title Width Font Color Check BoxesGroup Header #2 section, click Timestamp Creating an advanced report Selected field or formula moves to the Group by list Example of creating an advanced Skillset Threshold report Timestamp CallsAnswered CallsAnsweredAfterThreshold Group Header #1 section, click @RCWSkillsetNameID Group Header #2 section, click @RCWApplicationNameID Creating an integrated reportReport Name box, type Skillset Threshold Previewing a report Saving a reportOn the toolbar, click Import to Historical Reporting End Importing a report to Historical Reporting Interval Mode Table Name Timestamp Open RCW Report window, click Agent By Skillset Performance Report Title box, type Agent By Skillset Report Creation Wizard Step Action Defining configuration settingsInterval Mode Timestamp From the Report Type list, select HistoricalNodal Open a saved report in Report Creation Wizard Report Properties window, click Selection Criteria Defining selection criteriaIs greater than Is less than Not equal to Between Moving a field Report Creation Wizard Starts with Contains Ends with Resizing an object Adding a text field Modifying object properties Click the Object Properties tab Suppressing a report section Adding a field to or removing a field from a report Select the Section Properties tab Adding a formula to or removing a formula from a report Sorting the direction of a group, field or formula Sorting the order of a field or formula Viewing or modifying the object name in Crystal Reports Customizing the Report Creation Wizard template logo Applying template changes to existing reports Report Creation Wizard End