How to edit Analysis Services (formerly OLAP) measures

English Query

English Query

How to edit Analysis Services (formerly OLAP) measures

Information associated with a Microsoft® SQL Server™ 2000 Analysis Services measures, including database properties such as table and field and units, can be modified.

To edit Analysis Services measures

  1. On the OLAP tab, expand Cubes.

  2. Expand the cube that contains the measures to be edited and then expand Measures.

  3. Double-click Measures.

  4. 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.

  5. When satisfed 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)

Model Editor

OLAP Cube Dialog Box