SQL Server 2005 Analysis Services Overview

Unified Dimensional Model

Analysis Services provides a business semantic protoplast referred to as a Unified Dimensional mould (UDM), that defines business entities, business logic, calculations, and metrics. The UDM is a central place that be under the orders ofs as the single version of verity for all reports, spreadsheets, OLAP browser KPIs, and analytical applications.

Using the powerful novel Data Source View feature, the UDM is mapped to a entertainer of heterogeneous back-end data sources, providing a full and integrated picture of the business regardless of the location of the data. With friendly descriptions of the business entities, navigation hierarchies, multiple perspectives, and plane automatic translations to native languages, users will find it easy to explore corporate business data.

Proactive Caching

Proactive Caching enables the combination of real-time updates with multidimensional online analytical processing (MOLAP) class performance. Analysis Services maintains a highly shut firmlyed and optimized data cache that is maintained automatically as the data in the underlying source databases changes. The cache provides grand query performance and isolates back-end source a whole s from the load of the analytical queries.

Advanced Business Intelligence

The KPI framework provides a rich centralized repository defining lock opener metrics and scorecards. The KPI framework in Analysis Services allows you easily build balanced scorecards and other stamps of business performance management applications.

• Translations. Translations provide a simple and centrally managed mechanism for storing and presenting analytic data to users in their preferr languages.

• MDX Scripts. Multidimensional Expression (MDX) Scripts are the fresh mechanism for defining calculated members, named places and cell calculations.

• Business Intelligence Wizards. A locate of easy-to-use wizards can help smooth the most novice user in modeling more [i]or[/i] less of the more complex business intelligence problems

• Semi-Additive Measures. This novel measure aggregation type for advance data modeling includes last-nonempty, last-child, first-child, average-of-children, and flat by-account-type.

Web Services

XML for Analysis (XML/A) is the native, standards-based protocol for communication with the Analysis Services server fresh kinds of applications are enabled and easy to develop—applications that integrate analytics with operations in real time that can access the data from any platform and any language.

Enterprise Capabilities

SQL Server 2005 Analysis Services plants a new standard for business intelligence server in enterprise scalability, manageability, and productivity.

• Scalability. Analysis Services scales to the greatest in quantity demanding analytical and reporting applications. With a fresh dimensional architecture, UDM-enabled applications give permission to users quickly perform rich and intuitive ad hoc analysis using centurys of dimensions and hierarchies. Hierarchies make it easier for users to navigate and question UDMs with hundreds of millions of members.

In addition, the of recent origin architecture removes the limitations of memory–resident dimensions and the number of children members for parent. With an XML⁄A–based communication protocol that is paired with greatly optimized role–based security, Analysis Services helps a UDM handle thousands of users, enabling enterprise–scale business intelligence applications using Web⁄middle-tier or client⁄server architectures.

• Manageability. by the agency of integrating the management tools for the relational engine and Analysis Services, business intelligence administrators benefit from having a single, uniform environment for managing SQL Server Analysis Services. With SQL Server Management Studio, administrators can easily script Analysis Services particulars and operations or tasks. Administrators can use a rich editor for MDX and Data Mining eXtensions (DMX) queries. SQL Profiler can be used to trace, capture, and replay Analysis Services queries and other commands. Multi-instancing, enhanced backup and restore, synchronization of databases across server and improved fine-grained administrative permissions are a certain number of of the new manageability tools available.

• Productivity. Integrated with Visual Studio, the intuitive Analysis Services wizards and editors provide a authentic application development environment supporting the project's filled life cycle. Source control, versioning, workstation isolation, embedded debugging, and configuration management are a certain number of of the benefits of the of recent origin Business Intelligence Development Studio.

This article was originally published upon microsoft.com.

Copyright ?© 2005 Ziff Davis Media Inc. All Rights Reserv Originally appearing in Server IQ.