Create an Alias for a Model Column

Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Power BI Premium


Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.

In SQL Server 2017, you can create an alias for a model column. This might be useful when the mining structure name is too long to easily work with, or when you want to rename the column to be more descriptive of its contents or usage in the model. For example, if you make a copy of a structure column and then discretize the column differently for a particular model, you can rename the column to reflect the content more accurately.

To create an alias for a model column, you use the Properties pane and set the Name property of the column.

On the Mining Models tab of Data Mining Designer, the alias appears enclosed in parentheses next to the column usage label.

For information about how to set the properties of a mining model, see Mining Model Columns.

To add an alias to a mining model column

  1. In the Mining Models tab in Data Mining Designer, right-click the cell in the mining model for the mining column that you want to change, and then select Properties.

  2. In the Properties window on the right side of the screen, click the cell next to the Name property and delete the current value. Type a new name for the column.

See Also

Mining Model Tasks and How-tos
Mining Model Properties