Database Reference
In-Depth Information
2.
when the Process dialog window appears, verify that the Processing options
dropdown box is set to Process Full, and click Run at the bottom of the dialog
window.
3.
when processing succeeds, click Close to close the Process Progress window, as
shown in Figure 10-44 .
Browse Your Dimensions
After the dimensions are processed, you can test your design using the dimension browser.
1.
Access the dimension designer Browser tab by right-clicking the DimAuthors
dimension in solution Explorer and selecting Browse from the context menu.
2.
Click the Reconnection button on the Browser tab's toolbar, as shown in Figure 10-45 .
3.
use the treeview and the Hierarchy dropdown box to browse your dimension
attributes and hierarchies (Figure 10-45 ).
4.
Browse all of the other dimensions and check for any errors or inconsistencies.
In this exercise, you deployed, processed, and browsed the dimensions that you created earlier. It is now
time to create a cube so that these dimensions can be associated with our measures. Let's discuss how that
can be done in the next chapter.
Moving On
We have now completed the dimensions, but we still need to create cubes that use them! In our next chapter, we
create a cube, show how cubes and dimensions are interconnected, and discuss basic cube configurations.
LearN BY DOING
For this “Learn by Doing” exercise, configure dimensions similar to the ones defined in this chapter using
the northwind database. we have included an outline of the steps you performed in this chapter and an
example of how the authors handled them in two word documents. These documents are found in the folder
C:\_BookFiles\_LearnByDoing\Chapter10Files . Please see the ReadMe.doc for detailed instructions.
What's Next?
At this point, you now have a good idea of how dimensions are created and configured using Visual Studio.
But there is still so much more to tell. We are going to address some of these items in Chapter 11 , but for more
detailed information on this subject, we have found the following book to be quite useful. And although it is an
older book, most of the details still apply to all versions of SSAS from SQL 2005 and on.
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services]
By Marco Russo, Alberto Ferrari, Chris Webb
Publisher: Packt Publishing
ISBN-10: 1847197221
 
Search WWH ::




Custom Search