Creating Dimensions From the SQL Elements Panel - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Teradata Warehouse Miner
Release Number
November 2018
English (United States)
Last Update
Product Category

Still another way to create a new dimension value is to drag and drop a single SQL element from the SQL Elements panel to the empty space at the bottom of the Dimensions panel, or to drag and drop one or more column values displayed by clicking on the Values button. In the case of column values, a dimension value containing a single SQL Numeric Literal, String Literal or Date Literal is created as appropriate for each column value. This technique saves having to edit the properties of a numeric, string or date literal to set the desired value.

As with creating dimension values from selected columns, use of the right arrow selection button or double-clicking the desired SQL element or column value provides an alternative to dragging and dropping an element or value. Note, however, that repeated selection of a SQL element does not advance the selected element so the result is multiple dimension values containing the same SQL element. Also, when a SQL element is selected, the right arrow selection button will only be highlighted if neither a column or a column value is selected in its respective view.

When a SQL element is placed on top of another element on the Dimensions panel, whether by dragging and dropping it, selecting it with the right arrow or by double-clicking it, the new element is typically inserted into the expression tree at that point. The element replaced is then typically moved to an empty operand of the new SQL element.