In this step, you decide which of the fields in your source data you want to use as data fields. Data fields contain values that you want to summarize, such as sales amounts that you want to total. Select at least one field to be a data field.
The wizard has determined which fields may contain this kind of data and proposes them as data fields. The proposed fields are the checked ones that appear at the top of the list. You need to verify whether the wizard's proposals are correct and make any changes you want.
You must leave at least one field unchecked in this step. The fields you don't check in this step will be available for use as dimension fields, which are the fields that contain descriptive data and facts that serve as categories and line items in your reports. You'll select and organize the dimension fields in the next step.
To complete this step:
To summarize the same field by using more than one summary function, your query or selection of source data must contain one instance of the field for each summary function that you want. To add more instances of the field, click Cancel to exit the wizard; then add the fields to your query or selection, and run the wizard again.
The field names you assign in the wizard will appear in the reports you create from the cube. Whether you can change the field names in the reports depends on the type of reports you create.