Database Reference
In-Depth Information
Of course, the ability to accidentally leave of a filter and get meaningless
values is quite dangerous. With a slight tweak to your calculated measures,
you can fix that up. Change your two measures (Sum of Value and Status) to
the following DAX to show a value only when the DimOECDStatistics table
has only one value:
Sum of Value:=IF(
HASONEVALUE(DimOECDStatistic[Metric]),
SUM([Value]),
Blank()
)
BestOfPeers:=IF (HASONEFILTER(DimOECDStatistic[Metric]),
SUM([MaxOfPeers]),
Blank()
)
PErForMANCEPoINT SErVICES (PPS) SCorECArD:
TrAFFIC LIGHTS
In this section, you are going to create a scorecard using the standard
PerformancePoint indicator images for the KPIs. The data source you will be
using is from the Organization for Economic Development.
Start by setting up the data connection and mapping the date dimension as
described in Chapter 7. You are connecting to the OECD_Data tabular mode
cube.
To make the connection, right-click the PerformancePoint content list and
choose New
a
KPI. Select Blank KPI in the screen that follows. You will see a
screen like the one shown in Figure 10-11.
You need to map the KPI metrics to data points because they default to a fixed
value. Click 1 (Fixed Values) under Data Mappings on the same line with the
title Actual to start editing. In the screen that displays, click Change Source
and then double-click the data connection you created. In Figure 10-12, the
data connection is called dsOECD.
