Independencia

Analysis Services 2005 Migration
SQL Server Technical Article

Writer: Michael Young Technical Reviewer: Dave Wickert Published: May 2005 Applies To: Microsoft SQL Server 2005

© 2005 ProClarity Corporation

Executive Summary
This paper is a guide through the migration process to Analysis Services 2005. The introduction of the Unified Dimensional Model (UDM) provides designopportunities for cube developers that were simply not available before. The UDM has brought together the relational reporting and OLAP reporting worlds to provide a unified forum for both data request environments. Migrating to this new product is best done through understanding the new design options and determining how they affect your organization. The Migration Wizard is available as a toolthat will move your existing cubes to the new version of Analysis Services. It is a fast and effective tool. It is the goal of this paper to not only introduce you to the tool but also help you determine whether the tool is the best for you. In some cases it is better to redesign from scratch to ensure that you are properly leveraging the new features of Analysis Services 2005.

© 2005ProClarity Corporation

Copyright
Copyright © 2005 ProClarity Corporation. ProClarity and the ProClarity logo are trademarks of ProClarity Corporation. All rights reserved. All other trademarks are the property of their respective companies.

This is a preliminary document and may be changed substantially prior to final commercial release of the software described herein.

The informationcontained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.

This WhitePaper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.

Complying with all applicable 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 byany 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, trademarks, 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.

Unless otherwise noted, the example companies, organizations, products, domain names, e-mail addresses, logos, people, places and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, emailaddress, logo, person, place or event is intended or should be inferred.

2005 Microsoft Corporation. All rights reserved.

Microsoft and Visual Studio are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

© 2005ProClarity Corporation

Table of Contents
Introduction to Project REAL........................................................................... 2 Introduction .................................................................................................... 3 Cube Design Issues that Impact Migration...................................................... 3 Attribute Hierarchies...