Export (0) Print
Expand All
5 out of 6 rated this helpful - Rate this topic

Lesson 1: Preparing the Analysis Services Database

Designing a business intelligence application in SQL Server 2005 starts with the creation in Business Intelligence Development Studio of a SQL Server 2005 Analysis Services (SSAS) project based on an Analysis Services project template. After you create an Analysis Services project, you define one or more data sources. Then, you define a single unified view of the metadata, called a data source view, from selected tables and views from the data sources.

In this lesson, you will create an Analysis Services project, define a single data source, and add a subset of tables to a data source view.

This lesson contains the following topics:

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.