Specify a SQL or MDX Query (SSAS)

  • Article

This page of the Table Import Wizard enables you to import data by using a SQL or MDX query. To access the wizard from the SQL Server Data Tools, on the Model menu, click Import from Data Source.

The query can manipulate the data that is imported. For example, you could join data from different tables or select only rows that meet certain criteria.

Term

Definition

Friendly Query Name

Type a unique name for the query. This is a required field.

SQL Statement

Type or paste a SQL statement.

Validate

Determine if the SQL statement is valid.

Design

Design a SQL statement by using the query designer dialog box. For more information, see Relational Query Designer (SSAS).