Jump to: navigation, search

Genesys Interactive Insights

Also known as GI2. A presentation layer that extracts data from the Genesys Info Mart database, and presents it in readable reports to enable business and contact center managers to make better business decisions for streamlining operations, reducing costs, and providing better services.

For Genesys Cloud customers, depending on the release of Genesys Cloud that you are using, historical reporting is available through either the Genesys Interactive Insights (GI2) interface, or through Genesys CX Insights.



Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Workbin

In Multimedia, a contact-center object that holds interactions for later processing by a particular agent (or agent group, place, or place group). Agents can use workbins to store interactions on which they have started working, and on which they want to continue working at a later time. Interactions also can be distributed to workbins by Universal Routing Server (URS). A workbin is like a queue, in that it holds interactions. Nevertheless, a workbin differs from a queue in the following ways:

  • It is associated with a particular agent/place/group, and its major function is to hold interactions for that agent/place/group to process.
  • Agents can view the entire contents of the workbin, and pull interactions from it in any order. Agents also can pull interactions from queues, but only in the order that is defined by the queue.


Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Universal Routing Server

Also known as URS. The server that is used by Universal Routing that automatically executes routing-strategy instructions and distributes incoming customer interactions among contact-center agents. Previously known as Interaction Router.



Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Interaction Database

Also known as IDB. The database that stores data about contact-center interactions and resources at a granular level of detail.
See also Interaction Concentrator.



Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Genesys Interactive Insights

Also known as GI2. A presentation layer that extracts data from the Genesys Info Mart database, and presents it in readable reports to enable business and contact center managers to make better business decisions for streamlining operations, reducing costs, and providing better services.

For Genesys Cloud customers, depending on the release of Genesys Cloud that you are using, historical reporting is available through either the Genesys Interactive Insights (GI2) interface, or through Genesys CX Insights.



Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Key-Value Pair

Also known as a KVP. A data structure that is used to communicate or store a piece of information. A KVP consists of a key, whose value is an S.100 symbol, and a value, which may be any of a variety of data types, including a key-value set (thus, making the structure recursive). The key identifies the meaning of the data that is contained in the value.



Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

User Data Mapping

Genesys Info Mart provides a flexible storage mechanism for a potentially very large number of KVPs that are attached by Genesys solutions.

User Data Mapping Tables

The Info Mart database schema contains two mapping tables that are required to process and store user data:

  • CTL_UD_TO_UDE_MAPPING
  • CTL_UDE_KEYS_TO_DIM_MAPPING

The mapping tables instruct Genesys Info Mart on how to populate the user-data KVPs and where in the Info Mart database to store them.

[+] Show sample mapping table

To use user data in your reports, you must:

  1. Ensure that the upstream data sources (for example, T-Server) are configured to propagate user data as required.
  2. Configure ICON to store this data in IDB.
  3. Modify a Genesys-provided user-data script to work for your preferred KVP names.
  4. Adjust the Info Mart database to be able to store this data.
  5. Specify mapping rules for Genesys Info Mart to extract and process this data.

For information about how to customize the Genesys-provided user-data script for the initial deployment of Genesys Info Mart, see Customizing the User Data Template. Later, as your reporting needs evolve, you can similarly add more custom tables to the Info Mart database to store new user data KVPs.

Warning
GI2 customers please note: Some queries for out-of-box GI2 reports rely on inner joins to the IRF_USER_DATA_KEYS and IRF_USER_DATA_GEN_1 tables; if there are no KVPs mapped to these tables, out-of-box GI2 reports might yield inaccurate or unexpected results. To avoid the risk of missing records in tables that GI2 uses, Genesys strongly recommends that you not remove or disable the predefined user-data configuration.
[+] Show example

Viewing Current KVP Mappings

To view the current mapping of user-data KVPs to Info Mart tables and columns, execute the following SQL command against the Info Mart database:

SELECT * FROM CTL_UD_TO_UDE_MAPPING

The result will show both predefined and custom mappings in your deployment.

Mapping Call-Based Attached Key-Value Pairs

Genesys Info Mart extracts attached data KVPs from the ICON Voice details and ICON Multimedia details data sources — specifically, from the following IDB tables:

  • G_CUSTOM_DATA_S
  • G_USERDATA_HISTORY
  • G_SECURE_USERDATA_HISTORY
  • GM_F_USERDATA and GM_L_USERDATA

ICON automatically stores predefined router-specific KVPs in the G_ROUTE_RESULT table, provided that you configure URS to attach the KVPs to interactions. For more information, see Universal Routing.

ICON stores voice and multimedia attached KVPs in the G_USERDATA_HISTORY and G_SECURE_USERDATA_HISTORY tables, based on the options that you configure in the ICON application and in the ICON attached data specification (adata_spec) XML file. For multimedia interactions, ICON automatically stores predefined KVPs, including workbin usage details, in the G_USERDATA_HISTORY table.

ICON stores multimedia-specific attached data in the GM_F_USERDATA and GM_L_USERDATA tables. The storage and mapping of the attributes that Genesys Info Mart uses for multimedia-specific attached data is predefined, and Genesys Info Mart does not process any custom KVPs in the GM_F_USERDATA and GM_L_USERDATA tables.

By default, Genesys Info Mart stores the values of the KVPs that are listed in the “KVPs that are mapped by default” section of the table, Commonly Used Attached Data KVPs. If you want to store additional, custom user data, you must define mapping and propagation rules and store them in Control tables in the Info Mart database. Genesys Info Mart then extracts the user data details on the basis of the KVP name and stores the value in the table and column that you designate in the mapping tables (CTL_UD_TO_UDE_MAPPING and CTL_UDE_KEYS_TO_DIM_MAPPING).

As part of the mapping, you specify the propagation rule that Genesys Info Mart will use to determine what value to store if more than one value is extracted for the same key in the same interaction. For more information, see Propagation Rules.

You can also specify what value is stored as a default if a particular KVP is missing for an interaction.

Special Requirements

Be aware that your downstream reporting application might have specific requirements for user data that Genesys Info Mart does not store by default. For example, if you want to include reporting on social media metrics — such as Sentiment, Actionability, or Influence — in a GI2 deployment, GI2 has specific requirements for the user-data tables and columns that you must use to store the required KVPs.

For the convenience of GI2 customers, the sample ICON attached-data specification file that Genesys Info Mart provides includes commented-out lines that specify the social media–related KVPs that GI2 requires. For more information about configuring Genesys Info Mart to store the user data that GI2 requires for social media metrics, see the section about social media user data in the chapter about customizing the GI2 universe and reports in the Genesys Interactive Insights User’s Guide.

RDBMS Considerations

Depending on the RDBMS, you might have to consider RDBMS limitations when you specify customized mapping of KVPs to user-data dimension tables.

Microsoft SQL Server and PostgreSQL

An RDBMS limitation restricts the maximum length of index keys:

  • On Microsoft SQL Server releases earlier than 2016, to 900 bytes
  • On Microsoft SQL Server 2016+, to 1700 bytes
  • On PostgreSQL, to 2730 bytes

To avoid failures of the transformation job, the total length of values for KVPs that are configured to populate any one of the user-data dimension tables must not exceed the RDBMS limit.

For the KVPs that are mapped to any one of the user-data dimension tables by default, in releases earlier than 8.5.010.14 Genesys Info Mart restricts the length of individual user-data KVP values to 170 bytes (89 characters in multi-language Microsoft SQL Server databases), to ensure that combinations of KVPs do not exceed the limit.

Starting with release 8.5.010.14, in both single-language and multi-language Microsoft SQL Server databases the data types of certain user-data KVP columns was changed from varchar to nvarchar, without reducing the length of the values. As a result, the potential length of the indexes for some tables (for example, INTERACTION_DESCRIPTOR, various SDR_* dimensions) might exceed the RDBMS limit in deployments with Microsoft SQL Server versions earlier than 2016. For this reason, Genesys strongly recommends that Microsoft SQL Server deployments for Genesys Info Mart 8.5.010.14 and later use Microsoft SQL Server 2016 or later supported version.

This limitation does not apply to KVPs that are configured to populate user-data fact tables.

Oracle

There are no RDBMS limitations that you have to consider.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on August 17, 2018, at 06:15.