Analysis Services

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.

Top New Features

  • 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 design alerts.
  • 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.