O'Reilly logo

Pro SQL Server 2008 Analysis Services by Philo Janus Guy Fouché

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required