Chapter 3. Accessing Source Data

In this chapter, you will learn how to:

  • Use Business Intelligence Development Studio to create a business intelligence solution and an Analysis Services project.

  • Create a data source using the Data Source Wizard.

  • Develop a data source view using the Data Source View Wizard.

  • Create data source view diagrams.

  • Add logical primary keys and entity relationships to a data source view.

  • Create named calculations and named queries.

In this chapter, you will take the first steps toward creating an Analysis Services database, beginning by creating an Analysis Services project within a business intelligence solution. An Analysis Services project contains all of the code needed for one Analysis Services database. You will then add ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.