How to: Modify or Delete a Database Dimension in Solution Explorer

You can modify or delete a dimension by using Dimension Designer in Business Intelligence Development Studio. When you modify a dimension, your changes are not available to users until you process the dimension. For more information, see Processing in Analysis Services.

To modify a dimension in Business Intelligence Development Studio

  1. In Solution Explorer, navigate to the dimension that you want to modify, right-click the dimension, and then click Open.

  2. Under Data Source View, click the view that contains the item that you want to modify, and then make the changes you want.

To delete a dimension in Business Intelligence Development Studio

  • In Solution Explorer, right-click the dimension that you want to delete, and then click Delete.

See Also

Concepts

Defining and Configuring Dimensions, Attributes, and Hierarchies

Other Resources

Working with Dimensions, Attributes, and Hierarchies How-to Topics

Help and Information

Getting SQL Server 2005 Assistance