After you connect to an MPM OLAP cube in Excel 2007, use the PivotTable Field List to choose rows and columns for your report, apply filters, and add calculated fields. The PivotTable Field List automatically displays on the right side of the Excel worksheet.
To add fields from the PivotTable Field List to your MPM custom report, complete the following steps:
From the PivotTable field list, click the plus sign beside a measure or dimension to expand and display MPM fields.
Measures and dimensions may also have additional folders, such as Filters and More Fields, which you can also expanded to select items within them.
Do any of the following in the Field list to add a measure or dimension field to the report:
Select a field's check box.
Right-click the field name in the list, and select the appropriate command from the shortcut menu to add it to the report as a column, row, value, or filter.
From the field list, drag and drop a field into the appropriate report area (Column Labels, Row Labels, Values, and Report Filter) at the bottom of the PivotTable Field List.
(Optional) Click the arrow to the right of any field to filter the values for that field.
When you select an MPM field from the list, it is automatically placed in a default location in the report layout area on the left side of the Excel worksheet as follows:
Measures are placed as columns across the top of the report layout.
Dimensions are usually placed on the left as rows in the report layout.
The fields that you select from the PivotTable Field List are also placed in one of the default areas (Column Labels, Row Labels, Values, and Report Filter) at the bottom of the PivotTable Field List.
If you do not want a field located where Excel automatically places it, do either of the following to move it:
Move and re-order fields
Remove fields
Pivot Table Field Descriptions
Introduction to the MPM OLAP Cube
Connecting to an MPM OLAP Cube