Avaya NN44400-710 manual Creating an advanced report, End

Report Creation Wizard

Attention: Avaya recommends that you use a name different from the standard report definitions to quickly identify that it is a custom report and to determine the type of data that the report generates.

59Click Save.

--End--

Creating an advanced report

Select the Create Advanced Report (via ODBC) option to use an ODBC DSN. You can choose a combination of views from the data source. However, the views must include a common key field. This option provides the maximum flexibility, but it also requires that you understand the database structure with which you work.

Prerequisites

•Start Report Creation Wizard. See Starting Report Creation Wizard (page 126).

•Ensure that you are familiar with Report Creation Wizard.

•Configure the DSNs on the Contact Center Manager Server.

•Ensure that you understand table linking and joins.

Procedure steps

Step Action

1In the Report Type window, select the Create Advanced Report (via ODBC) option.

2In the Data Source window, from the DSNs Available list, double-click a DSN. The selected DSN moves to the DSNs Selected list.

Attention: You can select only one DSN system type, for example, a CCMS or CCMM DSN.

3The User ID and Password boxes automatically contain the values you enter during the server configuration. You can change the user ID and password, but these changes apply only if you create the report. If you generate the report in Historical Reporting, Historical Reporting uses the values you enter during the server configuration.

4Click Next.

5In the Table Selection window, from the Tables Available list, double-click a table. The table moves from the Tables Available list to the Tables Selected list.

6To add another table, repeat step 5.

7Click Next.

8If you select one table only, proceed to step 14.

NN44400-710 Contact Center Performance Management 12 November 2010 133