Chapter 5. Creating a Data Source View
Step 1: Get data. That's what we have to do if we're going to build a cube.
To get data into an Analysis Services cube, we need to build a data source view (DSV). The data source view is how we represent complex relational data models for our dimension and cube design. Before we create a DSV, we'll need to create the data sources we will use to populate it. And before we do that, we'll need to create a project in BIDS.
We'll do everything I've just mentioned in this chapter, after we cover some introductory material about the data for our cube.
Cubes Need Data
A data source view (Figure 5-1) is the layer of abstraction between a cube and the underlying data source. Although it looks like a simple ERD from a database, ...