Having prepared our relational source data, we're now ready to start designing a cube and some dimensions. This chapter covers the steps you need to go through in order to create simple dimensions and cubes, and although you may be confident that you know how to do this already, we encourage you to read through this chapter nonetheless. You may be familiar with the overall process, but some of the detailed recommendations that we make may be new to you, and they could save you a lot of time and effort later on in your project.
In this chapter, we'll be taking a look at the following topics:
Creating Data Sources and Data Source Views
Creating dimensions, setting up user hierarchies, and configuring attribute relationships
Creating a simple cube
Deployment and processing
From a methodology point of view, this chapter represents the creation of the first draft of your cube. In subsequent chapters, we'll look at how you tackle the more advanced modeling...