About reports database

Build 1501 on 14/Nov/2017  This topic last edited on: 5/Aug/2014, at 13:55

The reports database contains all the significant statistics of GN4 objects (also of the GN4 objects that have been already purged in the production database).

In an editorial environment, it contains properties and audit of page, layers, articles, texts, etc…

Using the Gemstone Reporting Tool, the user can retrieve data from the reporting database and generate the needed reports.

This document is about how to generate the reporting database from the objects of GN4 system.

Overview of the reports database

The reports database is created by GN4 workflows. The structure of the database (that is, the table’s names and columns) is defined into the configuration file of the workflow itself (the “wf_...”  xml file).

Because GN3 (the old version of the TeraDP Editorial System) provided a reporting database containing statistics about editorial objects, in GN4 has been created a workflow (“wf_GN4Report.xml”) which emulates the structure of the GN3 reports database.

So, to create and populate a GN4 editorial reports database, you have to run the wf_GN4Report.xml workflow with the correct parameters.

See also

GN4 report

ReportOptions

Configure the ReportOptions to store data in the reporting database

Report workflow activity

Avoiding duplicated data

wf_GN4Report.xml

Running wf_GN4Report.xml more times

Reporting database structure