Using Sql Server Analysis Services

Hands-On Lab
Lab Manual

SQL Server™ 2005:
Analysis Services















Information in this document is subject to change without notice. The example companies, organizations, products, people, and events depicted herein are fictitious. No association with any real company, organization, product, person or event is intended or should be inferred. Complying with allapplicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.Microsoft may have patents, patent applications, trademarked, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

2004 Microsoft Corporation. Allrights reserved.

Microsoft, MS-DOS, MS, Windows, Windows NT, MSDN, Active Directory, BizTalk, SQL Server, SharePoint, Outlook, PowerPoint, FrontPage, Visual Basic, Visual C++, Visual J++, Visual InterDev, Visual SourceSafe, Visual C#, Visual J#, and Visual Studio are either registered trademarks or trademarks of Microsoft Corporation in the U.S.A. and/or other countries.

Other product andcompany names herein may be the trademarks of their respective owners.


























SQL Server 2005 Analysis Services

Objectives
After completing this lab, you will be able to:

■ Create an Analysis Services cube
■ Create dimension attributes and hierarchies
■ Create calculated members and Key Perfomance Indicators (KPIs)



Note
This labfocuses on the concepts in this module and as a result may not comply with Microsoft security recommendations.




Note
The SQL Server 2005 labs are based on beta builds of the product. The intent of these labs is to provide you with a general feel of some of the planned features for the next release of SQL Server. As with all software development projects, the final version may differ from betabuilds in both features and user interface. For the latest details on SQL Server 2005, please visit http://www.microsoft.com/sql/2005/.




Estimated time to complete this lab: 90 minutes


Exercise 0:
Lab Setup

↙ Log on with user name Administrator and password pass@word1.


Exercise 1:
Creating an Analysis Services Cube

In this exercise, you will develop an Analysis Servicessolution using the Business Intelligence Development Studio, an environment based on the Microsoft Development Environment (Visual Studio 2005) shell.

You create Analysis Services projects in Business Intelligence Development Studio by using the Analysis Services Projects template. The Analysis Services project helps you organize and manage the items that are required to build, debug anddeploy an Analysis Services database.

The solution you are to develop is an Analysis Services cube, which is one of the most common tasks in Analysis Services. To help you with this, you have the new Cube Wizard with IntelliCube technology. This wizard simplifies creating an Analysis Services cube significantly. A cube and its dimensions can be created by using a single wizard because IntelliCubetechnology can detect the relationships between attributes, dimensions, and facts.

To create an Analysis Services cube, you will:

■ Create a Data Source containing the information Analysis Services needs to connect to a database.
■ Create a Data Source View containing schema information and Named Calculations.
■ Create a Cube containing data from multiple fact tables that have different...