Define the Properties of a Materialized Query Table

You use the Materialized Query Tables editor to add and change the properties of a materialized query table.

To define the properties of a materialized query table

Right-click a Materialized Query Table in the Model Explorer and select Properties from the drop-down menu.
The Materialized Query Table editor opens.
Work with the following options:

Name

Specifies the materialized query table name.

Schema

Specifies the default schema for the materialized query table.

Generate

Generates a CREATE MATERIALIZED QUERY TABLE statement for this materialized query table in the schema generation script when this check box is selected.
Click the From tab and select the tables or views you want to include in the materialized query table. Move the tables from the Available Tables and Views: list to the From: list. This action populates the Select tab.
Click the Select tab and specify the columns to include in the materialized query table. Move the columns from the Available Tables and Views: list to the Columns: list.
In the Select tab, you can create a materialized query column reference to any table column in your model. Work with the following options:

Alias

Edit the alias of the selected materialized query column.

New (Expression)

Opens the New Materialized Query Table Column dialog where you can enter a user-defined expression as a materialized query column.

Select Type:

Select an expression type from the drop-down list: All or Distinct.
Work with other options in the editor, then click Close.
Your changes are saved and the dialog closes.

Note: Click Cancel to close the dialog without saving your changes.

More information: