As of Friday October 16th, access to restricted content on this site now requires you to log in with your Genesys account. If you don't have an account, you can request one at these locations: Request MyPartner Portal Account or Request My Support Account.
Jump to: navigation, search

Composition of IWD Statistics and Aggregates

Each statistic is represented by a transformation script in the aggregate_stats\stats subfolder of the iWD ETL package. Each aggregate is represented by a transformation script in the plugins subfolder. Either script can define more than one statistic. As deployed during installation, the aggregate_stats\stats subfolder contains the following six sample scripts that define respectively six statistics:

  • department_activeheld.ktr
  • department_newcompleted.ktr
  • department_pendingoverdue.ktr
  • process_activeheld.ktr
  • process_pendingoverdue.ktr
  • solution_newcompleted.ktr

Also, the \plugins directory provides a file and five aggregate subfolders that correspond respectively to the five iWD aggregates:

  • \agent
  • \capt
  • \classif
  • \queue
  • \age

Each subfolder contains a plug-in script that includes the name of the aggregate: task_<agg>_fact (for example, task_queue_fact). You can add new statistics and have iWD aggregate them by creating additional scripts and identifying them to iWD.

Customizing Statistics

The recommended approach for creating custom statistics is the following:

  1. Copy an existing sample transformation script from the aggregate_stats\stats subdirectory. Name this script appropriately.

  2. Modify the script as appropriate using Kettle ETL Designer.

  3. Important
    Genesys does not provide Kettle ETL Designer directly. You can download the tool and instructions on how to use it from the Internet by using the following URL: Integration/2.5.2-stable/
  4. Enable the new statistic by adding it to the aggregate_stats\ file.

Customizing Aggregates

The recommended approach for creating custom aggregates is the following:

  1. Create a new subdirectory in the \plugins directory that is copied from an existing aggregate. Name this subdirectory appropriately.

  2. Modify the aggregate transformations as appropriate using Kettle ETL Designer.

  3. Modify the aggregate data structures as appropriate using SQL scripts.

  4. Enable the new aggregate by adding it to the plugins\ file.

This page was last edited on February 20, 2015, at 13:52.


Comment on this article:

blog comments powered by Disqus