This article describes the transforms you can use when creating a data cube (ETL process).

Enter an SQL statement to make a selection from a data connector instead of dragging native structures onto the canvas.

The MDX Select transform is created when a SSAS cube is dragged onto the canvas from the Data Connectors structure.

The SQL Select transform is created when a structure is dragged onto the canvas from a data connector that supports relational queries.

The Stored Procedure Select transform lets you retrieve data using a relational stored procedure.

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).

The Aggregate transform allows use of aggregate functions such as SUM, AVG, COUNT, MIN, MAX, etc.

The Calculated Element transform lets you create new elements by writing C# expressions. 

The Data Conversion transform allows change of data type of a column to another data type.

The Filter transform filters out rows that do not meet the configured criteria/settings.

The Join transform allows joining two tables by defining the keys and specifying the join type. If relationship exists between the two tables, the link is automatically created, but can be changed if necessary.

The Lookup transform joins data from input columns with column in a lookup table.

The Math transform lets you perform simple math functions such as Absolute, Ceiling, and Square Root on numeric input columns.

The String transform manipulates string columns in data tables by applying string functions.

The Union transform combines data from multiple structures by mapping columns onto one another.

The Python Analysis transform lets you write scripts using the Python programming language to perform analysis on data.

The Python Data Generator transform lets you generate data by writing scripts using the Python programming language.

The Data Input transform lets you reference a warehouse data storage area containing user input data.

The Copy Element transform creates new columns by copying selected input columns and adding the new columns to the output.

The Fuzzy Grouping transform allows grouping of records by looking at the similarity between the values of various columns.

  • 1
  • 2

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