Leveraging Performance Point Services - Microsoft Business Intelligence Tools for Excel Analysts - page 315

9. Click and drag the needed dimensions in the Details window to the Rows, Columns, and
Background areas (similar to building a Pivot Table in Excel).
10. Click the Home tab, and then click the Publish Item button to save your changes to the
server.
The Design tab has five distinct sections:
➤ The main window: Here you can see the current layout and results of your report as it will
appear in your dashboard. This view updates as you drag and drop cube dimensions or mea-
sures onto the cube drop area.
➤ The Details pane: This area on the right lets you browse the dimensions and measures of
the cube, which are defined based on your data connection. As you identify dimensions and
members that you want to use in your report, you can drag and drop them into the Rows,
Columns, or Background areas.
➤ The Rows, Columns, and Background areas: By dragging dimensions and measures from
the Details pane onto these areas, you effectively build a simple MDX query that is used to
populate your report. The Rows area corresponds to the horizontal rows of your grid. The
Columns area corresponds to the vertical columns of your grid. The Background area con-
tains any hidden filters you want applied to your grid.
Preparing your final dashboard
Dashboards generally have two or more reports, and at least one filter that operates on one or all of
the reports in the dashboard simultaneously (called a global filter ). In the PerformancePoint Content
window, to save time you can copy and paste when you want to generate multiple reports, filters, or
data connections that might have only slight variations. Figure 16-10 shows an example where the
first report (Internet Sales Amt) was copied and pasted into the PerformancePoint Content section,
and modified so that it would show Reseller Sales instead of Internet Sales.
The steps to do this are as follows:
1. In the Background zone of the new report, right-click the measure you want to duplicate and
select Delete (or click the x on the measure).
In this case, you right-click the Internet Sales - Sales Amt measure.
2. Drag the measure to the Background zone of the new report.
In this example, the measure is Reseller Sales - Sales Amt.
3. Rename the new report.
In this case, the new report is Reseller Sales Amt.