Database Reference
In-Depth Information
uu
Measure
a
MetricValueAvg
uu
Measure
a
MetricValueMax
uu
Measure
a
MetricValue
uu
DimCountry
a
Regions
uu
DimDate
a
YMD
uu
DimOECDStatistic
a
Statistics
Your query designer should look similar to Figure 13-18.
F I g u R e 13-18
The Report Builder query design screen for Analysis Services
Next, create three new parameters: Measure, X-Axis, and Y-Axis. Use XAxis and
YAxis for the actual name, and use X-Axis and Y-Axis for the prompt. For the
Measure parameter, add the Available Values shown in Table 13-1. The Value
fields are going to match the cube fields exactly so that this report can be
used with PerformancePoint later. Set the default to ReserveValue.
TABle 13-1
Measure Values
LABEL
VALuE
Reserve Value
ReserveValue
Metric Value Avg
MetricValueAvg
Metric Value Max
MetricValueMax
Metric Value
MetricValue
For the X-Axis and Y-Axis parameters, use the values Table 13-2. Set the X-Axis
default to Year and the Y-Axis default to GeoRegion.