Database Reference
In-Depth Information
In Figure 13-17, tiles with product images are used to slice the sales amounts
in the column graph below:
F I g u R e 13 -17
A tiled view in Power View
IMPleMenTATIon eXAMPleS
The implementation examples all use the OECD_Data model, so be sure you
have downloaded them from this topic's web page on Wrox.com.
SSrS: DyNAMIC MEASurES
Although Reporting Services isn't as dynamic as the other tools by default, it
is an exceptionally powerful toolset, and some measure of ad hoc analytics
can be enabled by using expressions.
For the purposes of this exercise, we will build the report by pulling in all the
data we require and then use expressions to choose which items to use. You
can also create dynamic queries, which will often perform much better.
Start by creating a new report in Report Builder and connecting to the OECD_
Data tabular model. Create a new data set named
dsoECD
and pull the fol-
lowing fields onto the design surface:
uu
Measures
a
Reserve Value
