Open topic with navigation
You can configure HPE Answer Server to store some information about the usage of your Answer Bank question equivalence classes in an ODBC-compatible database.
When you configure statistics storage, HPE Answer Server stores popularity information for your question equivalence classes. Each time the text of an Ask action matches a question equivalence class, HPE Answer Server updates the database.
Periodically, HPE Answer Server also queries the database for the popularity information, and uses it to update a count field in the question equivalence class. You can use this field to sort question equivalence classes by popularity in the
To configure Answer Bank to store statistics
Open your configuration file in a text editor.
Find the configuration section for the Answer Bank system for which you want to store statistics.
In this configuration section, set
StatsStorage to the name of a configuration section for the statistics database details. For example:
UpdatePopularityInterval to the number of seconds between updates of the question popularity field in the Answer Bank Agentstore.
By default, HPE Answer Server updates the field every 600 seconds (10 minutes).
You can update the field more frequently if you need up-to-date information to sort by popularity. However, for performance reasons HPE recommends that you do not update the popularity count field too frequently, because it might result in a large number of indexing operations in the Answer Bank Agentstore component.
PopularityWindowDays to the number of days for which you want to consider popularity information for your question equivalence classes in the Answer Bank Agentstore.
By default, HPE Answer Server stores the count for the last seven days. That is, each time HPE Answer Server updates the popularity field, it stores the number of times the question equivalence class was matched in the last week.
Create a configuration section for the statistics database. The name of this section must match the section you defined in the
StatsStorage parameter in step 3. For example:
In the statistics database configuration section, set
ConnectionString to the connection string to use to connect to the statistics database. HPE Answer Server passes this string on to the database, so you can use a connection string that works in any SQL client application. For example:
[MyStatsDB] ConnectionString=Driver=PostgreSQL ANSI(x64); Server=sql-host.mycompany.com; Port=5432; Database=statsdb; Uid=postgres;password=password;
The database that you configure must exist, but HPE Answer Server creates all the tables that it needs to store the statistics information. The database must also be able and configured to accept dates in ISO-8601 formats (that is,
On Linux operating systems, remove the spaces in the connection string.
True. The default value for this parameter is
True, but you might want to set it explicitly for clarity. You can set
False if you want to stop storing the statistics.
The following example shows the complete configuration for this statistics database.
StatsStorage=MyStatsDB UpdatePopularityInterval=600 PopularityWindowDays=7 [MyStatsDB] Enabled=True ConnectionString=Driver=PostgreSQL ANSI(x64); Server=sql-host.mycompany.com; Port=5432; Database=statsdb; Uid=postgres;password=password;
For more information about these configuration parameters, refer to the HPE Answer Server Reference.