Jump to: navigation, search

Reporting And Analytics Aggregates

Also known as RAA. An optional Genesys Info Mart process that creates and populates predefined aggregation tables and views within an Info Mart database. RAA aggregation tables and views provide the metrics that summarize contact center activity to facilitate reporting, and serve as the primary source of data for the Genesys CX Insights (GCXI) and Genesys Interactive Insights (GI2) historical reports. RAA is required for Genesys CX Insights and GI2 environments.



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. See also Genesys Info Mart, Reporting and Analytics Aggregates (RAA), and Genesys CX Insights (GCXI).



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 CX Insights

Genesys Customer Experience Insights (Genesys CX Insights or sometimes GCXI) provides a presentation layer that extracts data from the Genesys Info Mart database, and presents it in readable historical 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. See also Genesys Info Mart, Reporting and Analytics Aggregates (RAA), and Genesys Interactive Insights (GI2).



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

Preparing the Info Mart Database

This page provides a high-level overview of the steps to prepare the target Genesys Info Mart database and predefined views.

As Genesys Info Mart extracts source data and transforms and loads this data into the target tables, it operates with a single Genesys Info Mart database. The Info Mart database consists of the target fact and dimension tables (Dimensional model), Global Interaction Database (GIDB) tables, Merge tables (used for voice interactions only), Control tables, Staging tables, and Temporary tables. For more information, see Info Mart Database.

Overview: Preparing the Info Mart Database

  1. Set up RDBMS resources to support the reporting database.
    Create the database instance. For more information, refer to the documentation for your RDBMS.
    Important
    See the important notes on the Database Considerations page. In addition:
    • For Microsoft SQL Server, you must use a case-insensitive collation for the SQL Server instance and the Info Mart database.
    • For PostgreSQL, Genesys recommends that you use lower case for all schema names. If you cannot do so, specify the value in case-sensitive mode by surrounding the value with a set of double quotes.
    • For multi-language support in Oracle and PostgreSQL, you must create the Info Mart database with UTF-8 encoding. For links to more information, including requirements for related components that apply to Microsoft SQL Server as well, see Multi-Language Support.

  2. Create and configure the Info Mart database schema to process and store detailed reporting data.
    Prepare the databases by running Genesys-provided scripts:
    1. For reporting environments that require custom user-data storage, customize the user-data template script. See Preparing the User Data Script.
    2. For all deployments, create the Info Mart database schema. For more information, see Creating the Info Mart database schema.
    3. For deployments that include Voice details, customize the GSYS_DNPREMOTELOCATION table in GIDB, as required, to optimize performance of the merge operation. For more information, see Configuring Info Mart database for merge.

  3. (Optional, but recommended) Prepare database links, to streamline performance.
    Configure links between the IDB and Info Mart RDBMS servers. For more information, see Optimizing Database Performance: Database Links.
  4. Tune the Info Mart database.
    To improve ETL execution time, adjust the settings for the target database, as applicable to your RDBMS environment. For more information, see Optimizing Database Performance: Database Tuning.
  5. After you have installed Genesys Info Mart, complete database preparation.
    • If applicable, create read-only, tenant-specific views. For more information, see Creating Read-Only Tenant Views.
    • (Optional) Create custom calendar dimensions. For more information, see Creating Custom Calendars.
      Important
      If you plan to employ custom calendars in a deployment that includes the Genesys historical reporting presentation layer (GCXI or GI2) or the RAA package, configure the custom calendars before you start aggregation.

This page was last modified on April 12, 2019, at 06:16.

Feedback

Comment on this article:

blog comments powered by Disqus