SSAS 2005 Vs SSAS 2008

Posted on 2009-12-31
Last Modified: 2016-02-12
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?
Question by:Srinivas_Vengala
    LVL 3

    Assisted Solution

    There are some differences and new stuff yes. Mas says this and more @

    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


    Author Comment

    Yes.. these new features I have checked..  but I was more interested in the architectural differences if any?
    LVL 3

    Accepted Solution


    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.
    LVL 5

    Assisted Solution

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now