Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm asking this question since i'm planning to book a seminar, but the provider told me that they only offer trainings for SSAS 2008 or as individual training which are expensive.

So my question: would it be worthwile to book the SSAS 2008 seminar although we're using SSAS 2005 or are the differences too big?

share|improve this question
up vote 3 down vote accepted

I went through a pretty thorough 2008R2 training a year ago. It wasn't radically different from 2005, but it was different enough that you're going to face quite a bit of frustration when you can't do things in 2005, or the things you want to do are done differently. SSAS has been changing quite a lot over the last several releases. This is the list of changes between 2005 & 2008, and it's not small. The new designers are the things that are going to cause you the most pain.

share|improve this answer
Thank you for this helpful answer. So i've to look for other training offers that target SSAS 2005 or i have to swallow the pill. I don't see that we'll upgrade to 2008 in the near future. – Tim Schmelter Mar 12 '12 at 12:30
I'd add dynamic named sets (sets evaluated in the context of a query rather than once at startup), which isn't mentioned explicitly in the article but is quite useful. First appeared in 2008. – ConcernedOfTunbridgeWells Mar 12 '12 at 14:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.