Building a SQL Server 2005 Analysis Services cube tutorial

SQL Server 2005 Analysis Services (SSAS) projects are developed and deployed using the SQL Server Business Intelligence Development Studio that is installed as part of the SQL Server installation. SQL Server Management Studio, on the other hand can be used to manage the Analysis Services databases instantiated from these projects.

In this tutorial from Microsoft, you will learn how to build a SQL Server 2005 Analysis Services cube using the SQL Server Business Intelligence Development Studio. You will build the sample cube and deploy it on an instance of Analysis Services.

During the course of the tutorial, you will learn how to define data sources, data source views, cubes, dimensions, hierarchies and attributes. You will also learn how to view cube and dimension data by processing the deployed objects and populating them with data from the underlying data source.

Lesson 1: Defining a Data Source View within an Analysis Services project

Lesson 2: Defining and Deploying a Cube

Lesson 3: Modifying Measures, Attributes and Hierarchies

Lesson 4: Defining Advanced Attribute and Dimension Properties

Lesson 5: Defining Relationships Between Dimensions and Measure Groups

Lesson 6: Defining Calculations

Lesson 7: Defining Key Performance Indicators (KPIs)

Lesson 8: Defining Actions

Lesson 9: Defining Perspectives and Translations

Lesson 10: Defining Administrative Roles