Select Measures (Cube Wizard)

Use the Select Measures page to select the measures and measure groups to be created.

Note

This page will appear only if you have selected Build the cube using a data source on the Select Build Method page.

Options

  • Measure Groups/Measures
    Displays the available measures and measure groups.

    Note

    Measure groups have a shaded background and no text in the Source Columns column.

    To indicate that a measure or measure group is to be created, select the check box for that measure or measure group.

    To indicate that all measures and measure group will be created, select the Measure Groups/Measure check box in the header.

    To change the name of a measure or measure group, click the name of the measure group and enter a new name.

    To view sample data for a measure, right-click the measure, and then click View sample data. The sample data appears in the Data Sample Viewer dialog box. For more information about the Data Sample Viewer dialog box, see Data Sample Viewer Dialog Box (SSAS).

  • Source Columns
    Displays the source table and column for the measure.

See Also

Reference

Cube Wizard F1 Help (SSAS)

Other Resources

Cubes (Analysis Services)
Defining and Configuring Cubes and Cube Properties
Defining and Configuring Dimensions, Attributes, and Hierarchies

Help and Information

Getting SQL Server 2005 Assistance