March 22, 2007 07:22 PM

Moving Cubes from Analysis Services 2000 to 2005

Key concepts for deciding whether to migrate or rebuild your cubes in an upgrade
Rating: (0)
SQL Server Magazine
InstantDoc ID #95161
SQL Server 2005 Analysis Services (SSAS) provides many compelling reasons for upgrading from SSAS 2000. Among the many enhancements, SSAS 2005 provides more flexible analysis than SSAS 2000 by exposing most dimension attributes as analytical objects. But executing on the decision to upgrade comes with some challenges. Should you use SQL Server 2005's built-in tools to migrate your SSAS 2000 cubes? Or, with all the architectural changes in SSAS 2005, should you rebuild the cubes...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

I haven't personally encountered the message you mention but have seen it mentioned in newsgroups. You might find the post at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=64253&SiteID=1 to be interesting. Be sure to read the entire thread - it's not just about RS.
HTH,
Erin

Diana7/12/2007 11:20:05 AM


I experienced a problem with the migration of calculated members:

If their parent hierarchy is Measures,everything's ok.

But if that parent hierarchy is sg. else (e.g. a time dimension) then the following error occurs when trying to apply them as filters is the subcube area:
"Unable to apply filter. / A set has been encountered that cannot contain calculated members."

How can it be and how can I solve it?

István6/29/2007 1:47:07 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS