Delete cubes, dimensions, and hierarchies

To efficiently maintain models and ensure that they contain only relevant structures, you can delete objects such as cubes, dimensions, and hierarchies and their related objects.

Caution: Deleting an object can result in potential data loss. Therefore, to prevent unintended deletions, confirmation dialog boxes and lists of affected objects or dependencies are displayed. Deleted objects are removed from the OLAP database when you publish the model. Deleted objects can't be recovered after publishing.

This table shows affected objects and tables when you delete an object:


Action	Affected objects	Affected tables	Special cases
Delete a cube	These objects are deleted: Assignments to a cube such as dimension assignments Cube rules and rule groups Perspectives based on a cube	Objects that are related to these tables are deleted: DEPM_MOD_CUBE DEPM_MOD_DIMENSIONINCUBE DEPM_MOD_CUBEASSIGNMENT DEPM_MOD_CUBERULEGROUP DEPM_MOD_CUBERULE DEPM_MOD_MDACTABLE DEPM_MOD_FACTTABLE DEPM_MOD_PERSPECTIVE DEPM_MOD_DOMAINTABLE	Caution: Deleting an access cube can affect data security and other cubes that are assigned to data security. The Delete option is disabled for system cubes such as TABACC, and implicit cubes such as DAC and simple MDAC cubes.
Delete a dimension	These objects are deleted: All hierarchies within a dimension All subsets and subset elements that belong to a dimension All dimension attributes If assigned, the Dimension Access Control cube	Objects that are related to these tables are deleted: DEPM_MOD_DIMENSION DEPM_MOD_DIMENSIONATTRIBUTE DEPM_MOD_HIERARCHY DEPM_MOD_SUBSET DEPM_MOD_ELEMENTINSUBSET DEPM_MOD_DIMENSIONINCUBE	If a dimension is used in a cube, dimension deletion is blocked until the dependencies are removed. A list of cubes that use the dimension is displayed. Deletion of system and implicit dimensions is prevented.
Delete a hierarchy	All elements and subsets within a hierarchy are deleted.	Objects that are related to these tables are deleted: DEPM_MOD_HIERARCHY DEPM_MOD_SUBSET DEPM_MOD_ELEMENTINSUBSET	If a deleted hierarchy is used in a perspective, the perspective becomes invalid. You must fix the perspective manually. Deletion of system and implicit hierarchies is prevented.

Deleting a cube

Select Dashboards > Data Integrations > OLAP Modeling.
Select a model.
Select a cube to delete and, on the Properties tab, click Delete in the toolbar.
Alternatively, you can delete a cube in this way:
1. Select the Cubes node.
2. In the Actions column of the List of Cubes grid, select Actions > Delete for the cube to delete.
Review the warning about potential data loss and, if applicable, the list of affected objects or dependencies.
To confirm the deletion of the cube, click Delete.
You are redirected to the List of Cubes grid.

Deleting a dimension

Select Dashboards > Data Integrations > OLAP Modeling.
Select a model.
Select a dimension to delete and, on the Properties tab, click Delete in the toolbar.
Alternatively, you can delete a dimension in this way:
1. Select the Dimensions node.
2. In the Actions column of the List of Dimensions grid, select Actions > Delete for the dimension to delete.
Review the warning about potential data loss and, if applicable, the list of affected objects or dependencies.
To confirm the deletion of the dimension, click Delete.
You are redirected to the List of Dimensions grid.

Deleting a hierarchy

Select Dashboards > Data Integrations > OLAP Modeling.
Select a model.
Select a hierarchy to delete and, on the Properties tab, click Delete in the toolbar.
Alternatively, you can delete a hierarchy in this way:
1. Select a dimension that uses a hierarchy to delete.
2. Click the Hierarchies tab.
3. In the Actions column of the List of Hierarchies grid, select Actions > Delete for the hierarchy to delete.
Review the warning about potential data loss and, if applicable, the list of affected objects or dependencies.
To confirm the deletion of the hierarchy, click Delete.
You are redirected to the List of Hierarchies grid.