hi,
i am currently using a foodmart database i.e. MSAS2000 and i have installed newely MSAS2005. now i wanted to use the cubes of MSAS2000 i.e.Foodmart cube in MSAS2005. is it possible to move the cubes or migrate the cubes to MSAS2005. if yes then how if not then why and is anything done to do the upgradation or the migration.
thanks in advance for the answer
Can we use cubes of MSAS2000 in MSAS2005
jay1_z
This Project REAL paper should give you some guidance:
http://www.microsoft.com/technet/prodtechnol/sql/2005/asmigrtn.mspx
>>
Analysis Services 2005 Migration
SQL Server Technical Article
Applies To: SQL Server 2005
Summary: This paper guides you through the process of migrating to Analysis Services in SQL Server 2005. The Unified Dimensional Model (UDM) provides new design opportunities for cube developers. The UDM has brought together the relational reporting and OLAP reporting worlds to provide a unified forum for both data request environments. Understanding the new design options and how they affect your organization will optimize migration. The Migration Wizard is a fast and effective tool for moving your existing cubes to Analysis Services 2005. This paper introduces the wizard and helps you determine whether you should use it. In some cases it is better to redesign from scratch to ensure that you are properly leveraging the new features of Analysis Services 2005.
>>