Database Reference
In-Depth Information
Designing the
Data Warehouse for
Analysis Services
The focus of this chapter is how to design a data warehouse specifically for
Analysis Services. There are numerous topics available that explain the theory
of dimensional modeling and data warehouses; our goal here is not to discuss
generic data warehousing concepts, but to help you adapt the theory to the
needs of Analysis Services.
In this chapter, we will touch on just about every aspect of data warehouse design,
and mention several subjects that cannot be analyzed in depth in a single chapter.
We will cover some of these subjects in detail, such as Analysis Services cube, and
dimension design, in later chapters. Other aspects, which are outside the scope of
this topic, will require further research on the part of the reader.
The source database
Analysis Services cubes are built on top of a database, but the real question is: what
kind of database should this be?
We try to answer this question by analyzing the different kinds of databases we
encounter in our search for the best source for our cube. In the process of doing so,
we describe the basics of dimensional modeling, as well as some of the competing
theories on how data warehouses should be designed.
Search WWH ::
Custom Search