Edit a cube

A cube contains aggregated data from a semantic model's physical connection. You can rename a cube, delete it, or change its description, visibility, and availability. You can also edit elements in the cube that control the data that is aggregated and quantified in the cube.

For instructions on editing a cube or its elements, see the following topics:

• Rename a cube

  You can change the name of a cube to a new, unique name.

• Edit cube metadata

  You can edit cube metadata that describes the cube and controls its visibility and availability.

• Edit a simple measure in a cube

  Edit a simple measure to change the properties that describe the measure, control its visibility and availability, or define which data is pulled from the cube’s fact table.

• Edit a calculated measure in a cube

  Edit a calculated measure to change the properties that describe the measure, control its visibility and availability, and specify the formula and parent used to calculate the measure.

• Edit a measure created with SQL in a cube

  Edit a measure created with SQL to change the properties that describe the measure; control its visibility and availability; and specify the SQL expression, format, and default aggregation used to calculate the measure.

• Edit a dimension in a cube

  Edit a dimension, its hierarchies, and the levels of those hierarchies, to change the properties that describe the dimension and control its visibility and availability. Dimensions describe aggregated data in a cube so that the data can be grouped for analysis.

• Add a new hierarchy to a dimension

  Add new hierarchies to a dimension when you need to organize data in the dimension more granularly.

• Add a new level to a hierarchy

  Add new levels to a hierarchy of a dimension when you need to organize data in the hierarchy more granularly.

• Edit degenerate dimensions

  Edit a degenerate dimension, its hierarchies, and the levels of those hierarchies, to change the properties that describe the dimension and control its visibility and availability. Degenerate dimensions use only information in the cube's fact table to describe aggregated data so that the data can be grouped for analysis.