Running the Database View Definition report | Avaya NN44400-710

Expert reports

2Navigate to the CCMS installation directory. If you selected the default installation options then CCMS is normally installed at: D:\avaya\Contact Center.

3Navigate to the following default folder: D:\avaya\Contact Center\Common

Components\Cache\lib\.

4Copy the cacheDB.jar file from this location to the client computer.

5The JDBC url is jdbc:Cache://127.0.0.1:1972/CCMS_STAT on the CCMS server. When accessing this URL from the client computer, replace 127.0.0.1 with the IP address of the CCMS server.

6Use the ODBC user name and password to connect to the CCMS Server.

--End--

Running the Database View Definition report

Before you create a customized report, run the Database View Definitions report to display all the database views available. This report lists all of the field names available for use in your report.

The Database View Definition report does not include views from the Contact Center Multimedia database.

Procedure steps

Step Action

1From the Launchpad, click on Historical Reporting.

2Select the Contact Center Manager Server from which to run the report.

3Select the Configuration folder in Public Report Templates.

4Select Config - Database View Definitions.

5Click Run Now to generate the report.

6Click the Printer icon if you require a printout, or the Export icon to save the report.

--End--

Installing the Caché ODBC driver (CCMM)

To access the Contact Center Multimedia database from a report writer application, you must install the Caché ODBC driver and define the DSN. The Caché ODBC driver is supplied on the DVD.

102 NN44400-710 Contact Center Performance Management

12 November 2010

Image 102

$Avaya NN44400-710 Running the Database View Definition report, Installing the Caché Odbc driver Ccmm, Components\Cache\lib$

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 Filter management Prerequisites to 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 Real-time Reporting Prerequisites to real-time reportsLogging on to Real-Time Reporting Creating a private real-time display Real-time ReportingSelect the Public Tabular Displays folder Making a public copy of a private real-time display Deleting public displays Applying custom formulas to real-time 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 Deleting an exported real-time display grid Viewing the non-staffed skillsetsFrom the Displays menu, click Manage Exported Displays Page Exporting summary charts Exported displaysPrerequisites to exported displays Exporting network summary charts Exported displaysClick 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 Opening a graphical display Deleting 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 Adding a new column to a real-time display Customizing display propertiesClick 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 Logging on to Historical Reporting Applying filters to network consolidated historical reportsHistorical Reporting Defining the selection criteria Click the Public Report Templates folderClick 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 Installing the Caché Odbc driver Ccms Select Sybase ASE Odbc DriverClick Test Connect Page Select Intersystems Odbc Installing the Caché Jdbc DriverDefining the Caché Odbc DSN Ccms Cache Namespace, enter Ccmsstat Installing the Caché Odbc driver Ccmm Running the Database View Definition reportComponents\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 Setting the page orientation Creating reports using Microsoft ExcelChoose Data, Import External Data, New Database Query Creating reports using Microsoft Access Query Wizard-Filter Data box, click Next Expert reports Saving a report template in Crystal Reports Select the Preview the report optionSelect 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 Configuring real-time statistics collection Application Statistics Optional IVR Statistics OptionalAgent 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 Header field Title Width Font Color Check Boxes Group Header #1 section, click SkillsetGroup 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 Creating an integrated report Group Header #2 section, click @RCWApplicationNameIDReport Name box, type Skillset Threshold Saving a report Previewing 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 Defining selection criteria Report Properties window, click 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