How to edit an Analysis Services (formerly OLAP) cube

How to edit an Analysis Services (formerly OLAP) cube

The objects in the OLAP cube in the model can be changed.

To edit an OLAP cube

1. On the OLAP tab, expand Cubes.
   
   
2. Right-click the cube that to edit, and then click Edit.
   
   
3. Select the fact table and make the changes to Dimensions, Measure, Aggregation, Field and/or Units.

   To delete a measure, select it by clicking in the gray column to the left of it and then click Delete.

4. When satisfied with the changes, click OK.

See Also

Additional Relationships

Analysis Services in English Query

Enabling Analysis Services for an English Query Model

How to enable Analysis Services (formerly OLAP)

Level-Level Relationships

Model Editor

OLAP Cube Dialog Box

OLAP Tab (Model Editor)