Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

RtReports

TABLE OF CONTENTS

Relational datasets

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedAug 15, 2023
  • 3 minute read

A relational dataset retrieves the results of a SQL query to a relational data source in tabular format. Stored procedures saved in the data source may be used as the basis for a dataset.

To manage relational datasets:

  1. Under Datasets, choose Relational from the top-level page in the RtBaseline Services Administration site to open the Relational Datasets page.

    On the left side of the page, the Configured Datasets list shows the relational datasets already configured for RtBaseline Services. Dataset Properties appear on the right.

  2. Click New to Add a relational dataset, or select a configured dataset to view or update properties.

    You can also select a dataset, click Copy, rename it and change properties to create a new dataset. Click Preview to view a sample of the dataset, or Delete to Remove a dataset .

Dataset Properties

Enter or change dataset properties for one dataset at a time. The following items appear:

Data Set Name

A name used to access the dataset through RtBaseline Services. This value cannot be changed once a dataset has been saved.

Description

A description of the current dataset. This text is shown in the Datasets dialog box.

Data Source

Add a Relational Data Source Connection (, ) is used to create the dataset. The query is sent to this data source.

Cache Interval

An integer representing the number of seconds during which the web server caches the results of the query.

If Cache Interval is 0, results are not cached and the data source is queried every time that an update is requested.

Query Timeout

A command execution timeout for relational datasets, specified in seconds. The default value is 30 seconds (assumed for version 1.1 datasets). A 0 value means a timeout is not enforced.

The timeout applies to the full execution of the query; if partial results are returned by the data source, they are discarded and an error is returned if the timeout limit is exceeded.

Note that drivers or data sources may not be able to honor the timeout setting.

Stepped Plot

Plot data as a stairstep trace on trends. Clear the checkbox to display data as a curved trace on trends.

SQL Statement

The SQL statements or stored procedure used to retrieve data from the data source.

Open Query

Open the SQL statements to enter or import a SQL statement.

Verify SQL

Verify the syntax of the SQL statement against the database.

Clear

Clear the contents of the SQL Statement box, and all related placeholder and column values.

Data Source Time Zone

The time zone configured for the selected data source, used to determine the time context for absolute dates in date-time placeholder default values.

Placeholders

Each row of fields contains entry fields for SQL placeholders used in the SQL select statement. Values in these fields are used to verify SQL when previewing the data, and in client applications using the dataset.

Columns

Each row represents a column returned by the SQL statement. You can save a text description for each column name.

TitleResults for “How to create a CRG?”Also Available in