Documentation
Select
Data Cube Select
The Data Cube transform is created when another data cube is dragged onto the canvas.
Data Input
The Data Input transform lets you reference a warehouse data storage area containing user input data.
Manual Select
Enter a SQL or MDX statement to make a selection from a data connector instead of dragging native structures onto the canvas.
OLAP Select
The OLAP Select transform is created when a cube from an OLAP database connector is dragged onto the canvas.
SQL Select
The SQL Select transform is created when a structure is dragged onto the canvas from a data connector that supports relational queries.
Stored Procedure Select
The Stored Procedure Select transform lets you retrieve data using a relational stored procedure.
Tabular Select
The Tabular Select transform is created when you drag a structure onto the data cube canvas from a data connector that supports tabular data (e.g., Excel, XML, SQL Server table-valued functions).