Database Reference
In-Depth Information
Figure 9-56. Unchecking the unrelated attributes
9.
in the Completing the Wizard dialog window, change the name of your new
dimension to DimOrders .
10. Click Finish to complete the wizard.
11. Use the Build menu to verify that the Dimorders dimension builds successfully. if it
does not, troubleshoot the problem or delete the dimension from Solution Explorer and
go through the steps again, being careful to include any steps you may have omitted.
in this exercise, we created five dimensions using the Dimension Wizard. At this point, all the dimensions are
created but still need additional configurations.
Moving On
In this chapter, you saw how to create an SSAS project, data source, data source view, and five dimensions. We
have covered a lot, but we are still just beginning. In Chapter 10 , we configure each of the dimensions and then
create a cube that uses them.
LearN BY DOING
in this “Learn by Doing” exercise, you create a project and dimensions very similar to those defined in this
chapter. This exercise uses the northwind database. We have included an outline of the steps you performed
in this chapter as well as an example of how the authors handled this exercise in two Word documents.
These documents are found in the folder C:\_BookFiles\_LearnByDoing\Chapter09Files . Please see the
ReadMe.doc for detailed instructions.
What's Next?
Getting started with SSAS can be a tricky, but it gets easier the more you are exposed to it! For further study, we
have created videos that demonstrate the processes discussed in this chapter. You can find these videos at
http://NorthwestTech.org/ProBISolutions/Videos.
 
Search WWH ::




Custom Search