How to edit Analysis Services levels

The levels associated with each dimension can be edited to provide additional information and allow questions to be refined.

To edit Analysis Services levels

1. On the OLAP tab, expand Dimensions, and then expand the dimension whose levels are to be edited.
   
   
2. Right-click the level, and then click Edit.
   
   
3. Make the changes to the Level, Table, Field, or the level properties.

   To delete a level, 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

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 Dimension Dialog Box

OLAP Tab (Model Editor)