Database Reference
In-Depth Information
FIguRe 12-39 A radar chart
SSrS: A BuLLET CHArT
Reporting Services has a chart very closely related to the bullet chart—the
gauge chart—which you use to create the bullet chart.
Start by creating a data source connecting to the OECD tabular model, and
then create a new data set, and call it dsOECD. Pull the MetricValueAvg mea-
sure onto the design surface, drag DimOECDStatistics a Statistics onto the
parameters, and select the Production and Income a Productivity a Size of
GDP a GDP per hour worked metric. Check the parameter box.
Now drag DimDate a YMD onto the design surface, and choose 2011. Drag
DimCountry a Regions a CountryName onto the design surface.
Your design surface should look like the one shown in Figure 12-40.
The next step is to set a target, so you need to create a calculated measure. In
this case, you are going to create two measures: one target being the best GDP
per hour worked across the planet, and another one for the best GDP for the Sub
Region. To create a calculated measure, right-click in the box in the lower-left
corner, and choose New Calculated Member. Your code will be the following:
CASE WHEN [Measures].[MetricValueAVG] = NULL THEN NULL ELSE
MAX( [Measures].[MetricValueMax], [DimCountry].[Regions].[All])
END
And the screen should look like Figure 12-41.
Search WWH ::




Custom Search