Reports
Features
Reports can be automatically generated to run on a configured schedule providing data in CSV, PDF or HTML formats. They can also be triggered to run as an action, for example a report can be configured to run when an SLA is breached.
Report Types
Reports are generated by performing one or many data queries and using a template to format the data. There are 4 options for querying the data contained in the report, a single report can use a variety of these:
Elasticsearch Report
Queries data from an Elasticsearch datastore. Configured by selecting an Elasticsearch datastore (this can be the Germain UX Datamart) and providing a SQL query.
Scripted Report
In the event that the above options cannot support your use case, you can use Scripted Report for more complex report. For instance, Elastic / NoSQL databases in general do not support JOINs between different indexes, since all data is stored distributed across many nodes.
Ability to write JavaScript script that can fetch data from Germain UX Datamart
Utility functions that can be used to query related data:
Get parent / children
Get all ancestors (ex: from SQL query up to User Click)
Get all descendants (ex: from User click down to all SQL queries)
etc
Simple Query Report
Queries data from the Germain UX Datamart. Configured by selecting preconfigured options from dropdowns.
SQL Report
Queries data from a Relational Database (Oracle, SQL Server, MySQL, etc). Configured by selecting a database (this can be the Germain UX Datamart) and providing a SQL query..
Report Editor
The report editor allows you to edit/preview existing queries, add new queries and navigate to the Report template. It has the following layout:
Feature Availability: 2024.2 or later