---
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 [!INCLUDE[ssBIDevStudioFull](../../includes/ssbidevstudiofull-md.md)]. 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](processing-a-multidimensional-model-analysis-services.md).  
  
### 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](processing-a-multidimensional-model-analysis-services.md).  
  
### 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](dimensions-in-multidimensional-models.md)