Database Reference
In-Depth Information
Testing the KPI
1.
Click the browser View button on the KPi toolbar of the KPi tab (as circled in Figure 9-47).
2.
Change the filter so that only the quantity for a single title is shown. You can do this
by setting Dimension to DimTitles, Hierarchy to Title, operator to Equal, and the filter
expression to a single title, as shown in Figure 9-48.
3.
Click the results pane to evaluate the new filter expression. The results should now
show the sales quantity of a single title and indicate whether it met the goal of 25 to
50 units.
in this exercise, you created and tested a KPi. KPis are useful additions to reports, and many managers
prefer them to tabular pivot table reports.
Moving On
We have now created a cube and examined the first five tabs of the cube designer window, but we still have
another five tabs to go! In the next chapter, you learn how these other tabs are used to configure a cube; we also
show you some additional dimension configurations that are not needed for our current DWPubSales project but
are commonly used in the industry.
LEARN BY DOING
in this “Learn by Doing” exercise, you configure dimensions similar to the ones defined in this chapter using
the Northwind database. We have included an outline of the steps required as well as an example
of how we handled them in two Word documents. These documents are found in the folder
C:\_BookFiles\_LearnByDoing\Chapter11Files
. Please see the
ReadMe.doc
file for detailed instructions.
What's Next?
You now know how dimensions and cubes are interconnected and have learned several cube configurations.
In the previous chapter, we recommended the book
Expert Cube Development with Microsoft SQL Server 2008
Analysis Services
by Marco Russo, Alberto Ferrari, and Chris Webb (Packt PublishingISBN-10: 1847197221). We
recommend that book once again for the subject matter covered in this chapter.
