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.