Skip to main content

Data Group

The following describes the historical data group settings specific to this connector. For information on common features such as the Columns and Time Period Tabs, please refer to Historical Data Groups documentation.

Group Type

The following group types are available for this connector:

image8.png
  • Summary Values from XLReporter

    Summary values are calculated by XLReporter. Select use raw values to base calculations on raw values otherwise they will be based on sampled values from the Server.

  • Raw Values

    Numeric values from the Server

  • Custom Values

    Custom values queried from any table/view in the historian database using the Database Group.

Group Settings

Setup Tab

image5.png

Database

The Database settings indicate the table and column(s) for the timestamp. If Definition is set to Connector, the settings from the connector are used. If set to Specific, any appropriate table in the database can be selected.

Retrieval

The Retrieval settings is only enabled for summary values.

  • Retrieval Mode

    This setting defines how data is retrieved from the historian. Only Raw Values are available.L

  • Lead Time

    The amount of time (in seconds) to retrieve data before the start time.

Filters Tab

If the Perform by Server option is checked, any filter configured in this tab is put into the WHERE clause of the query sent to retrieve data for the group. Otherwise, the configured filtering is performed by the reporting engine after the values are returned. It is recommended to leave this setting checked as the performance is much better.