Skip to main content
Skip table of contents

Bases

A metric base contains SQL fragments (From and Where clauses) that specify the source tables from which the metric's data is taken. The data on which the metric base acts can exist in different tables with different granularity and periodicity or currency (real-time, frozen or snapshot data, etc.).

To view Metric Base definition settings, choose Content Definitions in the Navigation tree, then Bases. Open the appropriate Metric Base folder(s) and select the metric base to open the View Properties window.

Metric Base Settings

Setting

Description

Connection

Once defined under the Connections folder, these objects are now available in this drop-down list. This is used to provide connection information to the database when a dynamic query is used. In almost all cases, the "DW Read" link near the bottom of the list should be selected.

Style Template

The metric style template that is used as the default style template for any metric using this metric base.

Base Statements (Inner Query)

Setting

Description

From Clause

The SQL fragment that is used for the FROM clause in any metric using this metric base.

Where Clause

The SQL fragment that is added to the WHERE clause in any metric using this metric base.

Custom Statements (Outer Query)

Setting

Description

From Clause

The SQL fragment that is used for the FROM clause in any metric using this metric base.

Where Clause

The SQL fragment that is added to the WHERE clause in any metric using this metric base.

JavaScript errors detected

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

If this problem persists, please contact our support.