Database Reference
In-Depth Information
Building Basic Dimensions
and Cubes
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 problems. However, there are a lot of advantages in taking an
iterative and incremental approach to cube development. If you're unfamiliar with
your data or Analysis Services, it will allow you to get something up and running
quickly so that you can be sure that it works properly.
Search WWH ::
Custom Search