Analysis Services

Take advantage of the improved Aggregation Designer to optimize Online Analytical Processing (OLAP) performance and eliminate unnecessary aggregations with block computation

Enable high-performance “what if” scenarios by using the new Multidimensional OLAP MOLAP enabled write-back capabilities

Scale out Analysis Services by sharing one read-only Analysis Services database between several Analysis Services servers

Add global scalability to your solutions and give all users access to localized analytical data in their native language with powerful translation capabilities and automatic currency conversions

Benefit from using a single tool in the form of Business Intelligence Development Studio throughout the entire development lifecycle

Detect potential design issues as they arise with automatic notifications provided by best practice design alerts

Accelerate and enhance the development process with intuitive cube, dimension, and attribute designers

Enable the combination of real-time updates with MOLAP class performance with Proactive Caching

Take advantage of a highly compressed and optimized data cache that is maintained automatically as data in the underlying source databases changes

Use Proactive Caching to provide superb query performance and isolate data source systems from the load of analytical queries

Optimize backup performance easily by taking advantage of a scalable backup solution that offers performance comparable to that of a file copy operation

Use the Unified Dimensional Model to provide one consolidated business view for relational and multidimensional data that includes business entities, business logic, calculations, and metrics

Facilitate business information modeling, and employ easy to use Business Intelligence wizards to effectively build in time and financial intelligence

Manage enterprise-wide key performance indicators (KPI’s) centrally by using the Analysis Services KPI Framework — a rich centralized repository for defining, storing, and managing KPIs

Make centrally stored KPIs available to users through a variety of applications, including Microsoft Office PerformancePoint Server 2007, Microsoft Office Excel 2007, Microsoft Office SharePoint Server 2007, and SQL Server Reporting Services

Offer advanced analytical capabilities that enable users to learn from large volumes of historic data, perform predictive analysis, and proactively identify patterns and business trends

Extend the predictive analysis capabilities of SQL Server with enhanced data mining engine and improved algorithms, and strengthens the powerful data mining framework represented by the extensible .NET programming model and embeddable data mining viewers even further

Enable business users to access multidimensional data directly from within the familiar environment of Office Excel 2007; empowering them to effortless explore the data they need when they need it

Enjoy the power of the predictive and sophisticated analytical capabilities of data mining directly from Office Excel 2007 by using the SQL Server Data Mining Add-Ins

Use the tight integration of Analysis Services with Office PerformancePoint Server 2007 to help provide rich performance management capabilities that bring together monitoring, analysis, and planning

Enable centralized access and collaboration to analytical data through deep integration with Office SharePoint Server 2007 or access data through the application of your choice; benefitting from more than100 partners building on top of Microsoft SQL Server Analysis Services

Develop new applications that integrate analytical capabilities with operations in real time

Expose your data using XML for Analysis (XML/A), which is the native, standards-based protocol for communicating with the Analysis Services server

Using XML/A as the native protocol, you can Configure Analysis Services clients to have a zero footprint, and each server is automatically a Web service

Support tools that work with Analysis Services 2000 on OLE DB for OLAP, ADOMD, and ADOMD.Net

Light-footprint Win32 layer is available for backward compatibility with tools that work with Analysis Services 2000 on OLE DB for OLAP, ADOMD, and ADOMD.Net