database-dimensions-modify-or-delete-a-database-dimension-in-solution-explorer.md

title	Modify or Delete a Database Dimension in Solution Explorer | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	analysis-services
ms.topic	conceptual
helpviewer_keywords	modifying dimensions dimensions [Analysis Services], deleting dimensions [Analysis Services], modifying deleting dimensions removing dimensions
ms.assetid	be52b351-f376-42ee-adba-2dcaa0c0f69c
author	minewiskan
ms.author	owend
manager	craigg

Modify or Delete a Database Dimension in Solution Explorer

You can modify or delete a dimension by using Dimension Designer in [!INCLUDEssBIDevStudioFull]. When you modify a dimension, your changes are not available to users until you process the dimension. For more information, see Multidimensional Model Object Processing.

To modify a dimension in SQL Server Data Tools

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

2. On the Dimension Structure tab, in the Attributes, Hierarchies, or Data Source View panes, click the item that you want to modify, and then make the changes.

   For more information about the types of changes that you can make, see Multidimensional Model Object Processing.

To delete a dimension in SQL Server Data Tools

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

See Also

Dimensions in Multidimensional Models