SSAS 2005 Vs SSAS 2008

Can someone please tell me how SSAS 2008 is different from SSAS 2005? I mean are there any differences in architecture? Any major changes and new features?
Srinivas_VengalaAsked:
Who is Participating?
 
ppangoCommented:

This is a change:

Open Embeddable Architecture (has been added/extended)

Analysis Services has long supported OLE DB for OLAP, ADOMD, and ADOMD.Net, but this is extended by SQL Server 2008 Analysis Services to expose data using the XML for Analysis (XML/A) standard. Each Analysis Services server is now a provider of web services and, as such, this makes it straightforward to integrate analytical data into modern applications.
0
 
ppangoCommented:
There are some differences and new stuff yes. Mas says this and more @ http://www.microsoft.com/sqlserver/2008/en/us/analysis-services.aspx

Develop solutions quickly with the new, streamlined Cube Designer
Take advantage of enhanced Dimension and Aggregation Designers
Create attribute relationships easily by using the new Attribute Relationship Designer
Avoid common design problems by using best practice
Optimize performance with subspace computations
Enable high-performance what if scenarios by using MOLAP enabled write-back
Take advantage of enhanced data mining structures and improved Time Series support
Monitor and optimize analytical solutions by using Analysis

Rgds,
Ppango
0
 
Srinivas_VengalaAuthor Commented:
Yes.. these new features I have checked..  but I was more interested in the architectural differences if any?
0
 
grzegorzsCommented:
One of interesting new features is so called "Static tree normalization". It is a part of parsing MDX query. During this stage SSAS performs type conversions and replaces some functions from query with corresponding SSAS object, e.g. function [Time].Level(1) could be replaced with Time.Year (if Year is level in Time dimension). In previous versions of SSAS type conversions were performed during cell calculations. This could result in bad query performance.

best regards
Grzegorz
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.