Removing Attributes from a Dimension
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 Business Intelligence Development Studio, 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.