Skip to main content
Skip table of contents

Reports (Automatic)

Features

Reports can be automatically generated, in CSV, PDF or HTML formats. And you can create your own automatic report.

SQL Report

Report in CSV format can be automatically generated at a set interval, by pulling data from a relational database (oracle, sql server, mysql, etc).

Elasticsearch Report

Report in CSV format can be automatically generated at a set interval, by pulling data from an Elasticsearch datastore.

Scripted Report

In the event it isn't possible to use SQL to pull data from a database, 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 MVEL script that can fetch data from Germain datamart and transform into result set

  • 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

Feature Availability: 8.6.0 or later

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.