Tabular Select

Contents[Hide]

The Tabular Select transform is created when you drag a structure onto the data cube designer canvas from a data connector that supports tabular data (e.g. XML, CSV, SQL Server table-valued functions).

1. Input

The structure of the table dropped on the Data Cube canvas is used as input. For example, the structure is:

Transform - Tabular Select
Transform - Tabular Select

2. Add the Transform

Steps to add the transform:

  1. Drag and drop the file to the Data Cube Designer.

    Adding the Tabular Select transform - Step 1
    Adding the Tabular Select transform - Step 1

  2. To Edit/Configure the transform, select the transform node, and click the Configure menu.

    Opening the Configuration dialog
    Opening the Configuration dialog

3. Configure

Steps to configure the Tabular Select transform:

Tabular Select transform configuration - Screen 1
Tabular Select transform configuration - Screen 1

  1. Timeout - the length of time, in seconds, before terminating the attempt to execute a command.
  2. Select the columns to be included in the output.
  3. You can skip this step. Unlike SQL Select transforms, tabular data (e.g. data from Excel and flat files) do not have options for aggregator and grouping.
  4. Optional - if you require additional columns using an expression, click on the New icon just below the Select Expression field.

    Tabular Select transform configuration - Add Select Expression
    Tabular Select transform configuration - Add Select Expression

    • 4.1 Name - the column name.
    • 4.2 Description - Description of this column.
    • 4.3 Expression - SQL Expression
      To use aggregators (e.g. SUM, AVG, etc.) and GROUP BY when using tabular data, you need to use the Aggregate transform.

4. Output

The figure below illustrates the output from the Tabular Select transform.

Tabular Select - Sample Output
Tabular Select - Sample Output

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri