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, ...
Get Pro SQL Server 2008 Analysis Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
