United States   Change   |   All Microsoft Sites


Analysis Services

Enterprise-Scale Analytic Solutions

Microsoft SQL Server 2008 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.
  • Build enterprise-scale solutions

    Rely on Microsoft SQL Server 2008 to scale demanding analytical applications with millions of records and thousands of users.

  • Extend solutions with comprehensive analytics

    Use the richness of a single Unified Dimensional Model (UDM) to accommodate multiple analytical needs—from multidimensional analysis and reporting to predictive analysis—all in one solution.

  • Deliver intelligence insights through familiar tools

    Enjoy the extensibility of an open, embeddable architecture, and empower users through optimized interoperability in the 2007 Microsoft Office system, enabling the delivery of pervasive insight to everyone.

Highlighted Capability

Attribute Relationship Designer

Attribute Relationship Designer

Click image to see larger view

Top New Features

  • Develop solutions quickly with the new, streamlined Cube Designer.

  • Take advantage of enhanced Dimension and Aggregation Designers. Watch the short demo.

  • Create attribute relationships easily by using the new Attribute Relationship Designer.

  • Avoid common design problems by using best practice design alerts. Watch the short demo.

  • Optimize performance with subspace computations.

  • Enable high-performance “what-if” scenarios by using MOLAP-enabled writeback.

  • Take advantage of enhanced data mining structures and improved Time Series support.

  • Monitor and optimize analytical solutions by using Analysis Services Dynamic Management Views for enhanced resource monitoring.


Compare all features supported by the SQL Server 2008 editions.