Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Contact Center Analytics >

Setting Up the Benchmarks and Targets Table

The benchmarks and targets subject area is used to establish targets for various metrics for your Contact Center and also capture industry benchmarks for the same metrics. The values of these metrics are calculated using the Contact Center Performance subject area and are compared to the Benchmarks and Targets table to evaluate the performance of your Contact Center.

When setting up the Benchmarks and Targets table you must consider the following:

• The file_cc_bmk_tgt.csv file must supply the effective date range for each benchmark record. The date range is used to identify the appropriate benchmark to compare with the actuals and the determination of other metrics such as the Service Level. Actuals refers to the actual value of the metric (during the period) as opposed to the planned or targeted value of the metric.
• You need to supply an appropriate date range for the benchmark records. For example, if the benchmark records do not vary over time, a large date range can be used as shown in the following table:

• The Benchmarks and Targets table is preconfigured at the contact level. You can define other benchmarks and targets, for example, an Hourly-Total-Hold-Duration benchmark, and these can be added using the extension columns in the data warehouse. For more information on the methodology for storing additional data in the data warehouse, see Storing, Extracting, and Loading Additional Data.
• For each dimension in the Benchmark and Targets fact table, you can decide if a benchmark or target varies by that dimension or not. If you choose to keep a benchmark or target constant over a dimension, you need to supply a question mark (?) as the value for the dimension ID. In addition, the metric needs to be leveled in the repository at the grand-total level of that dimension. This dimension ID also needs to be removed from the join in the SQL statement in the M_CC_ORGLOC_A1_EXTRACT_SERVICE_LEVEL mapping. If you choose to vary a benchmark or target by a dimension, you need to provide benchmark or target for each value of the dimension.
• The FORECAST_CNTCT_CNT table in the source file is preconfigured to forecast the number of calls for a day for a combination of dimensions.

The Benchmarks and Targets table is preconfigured with the smallest effective date range of a day. To changing the grain to be hourly, perform the following procedure.

To configure the grain of the Benchmarks and Targets table

1. Add the Hour Key to the IA_CC_BMK_TGT fact table.
2. Modify the M_F_CC_BMK_TGT_EXTRACT and M_F_CC_BMK_TGT_LOAD mappings to populate the Hour Key based on the Period Start Date and Period End Date.

   These dates need to fall on the hour boundaries and not in the middle of an hourly interval.

3. Modify the M_CC_ORGLOC_A1_EXTRACT_SERVICE_LEVEL mapping SQL statement to now join also on Hour Key to the Benchmarks and Targets table.
4. Modify the metadata in the repository to include the new physical and logical joins to the IA_HOUR_OF_DAY dimension.
5. Set the content pane settings on the fact table to the newly added Hour (Time) dimension.

To set up the Benchmarks and Targets table

1. Open the file_cc_bmk_tgt.csv file using Microsoft WordPad or Notepad in the $pmserver\SrcFiles folder.
2. Type in your data to load the Benchmarks and Targets.
3. Save and close the file.