Remove an Attribute from a Dimension
Applies To: SQL Server 2016
To remove an attribute from a dimension in Microsoft SQL Server Analysis Services, right-click the attribute in the Attributes pane of the Dimension Structure tab of Dimension Designer in SQL Server Data Tools (SSDT), and then click Delete. In the Delete Objects dialog box, click OK. This removes the attribute from the dimension, but does not affect the data source view for the dimension.