Databases Reference
In-Depth Information
Notes about the scorecard
At this point, you have created one KPI and one scorecard and associated one dimension with the
KPI. You can build more KPIs and add more dimensions to give business users more options for slic-
ing data that they need to view, and much more. Here are a few more scorecard elements that you
should explore:
You can use the Details pane to navigate the elements that you can add to the scorecard,
which can dynamically change how your data is visualized.
You can add metrics on the opposite axes from all KPIs.
You can use aggregations on the scorecard to make summations of all the metrics. You simply
add the aggregation type above the metric column. Aggregations are limited to columns (no
row aggregating).
You can place named sets (from the cube) on a scorecard.
Using Set Formulas, you can add MDX or Time Intelligence expressions to the scorecard to
further filter the data that is viewed by the user.
Creating a filter
You want to include one filter on the dashboard to give users the option to select from other territories.
To create one, perform the following procedure:
In the Workspace Browser, right-click the PerformancePoint Content.
1.
On the shortcut menu that appears, point to Select New. On the submenu that appears, click
Filter
2.
In the dialog box that opens, click Member Selection.
3.
Select the AdventureWorks data source and then click Next.
4.
Click Select Dimension.
5.
In the Select Dimension dialog box (see Figure 8-43), click Geography.Countr y Name and then
click OK.
6.
7.
In the Create A Filter dialog box, click Select Members and then, under Europe, select All
Countries.
On the Select Display Method page, click List and then click Finish, as shown in Figure 8-44.
8.
Search WWH ::




Custom Search