Balanced Scorecard Spreadsheets Represents Kpi - PDF - PDF

							With SQL Server 2005, Analysis Services     as the cornerstone of your Business              Analysis Services 2005 maintains a
provides, for the first time, a unified       Intelligence (BI) infrastructure and with        highly compressed and optimized data
and integrated view of all your business    the deep integration with SQL Server             cache that gets automatically maintained
data as the foundation for all of your      2005 Reporting Services and with                 as the data in the underlying source
traditional reporting, OLAP analysis, Key   Microsoft Office, Analysis Services               databases changes. The cache provides
Performance Indicator (KPI) scorecards      2005 will extend business intelligence           superb query performance and isolates the
and data mining.                            to every level of your business.                 back-end source systems from the load of
By introducing a single Unified                                                               the analytical queries.
Dimensional Model (UDM), Analysis           Unified Dimensional Model
Services combines the flexibility and        By combining the best aspects of traditional     Advanced Business Intelligence
richness of the traditional relational      OLAP analysis and relational reporting,          ●  Key Performance Indicator (KPI).
reporting model with the user-friendly      Analysis Services 2005 provides a                   The KPI framework provides a rich
powerful analytics and the superb           metadata model that covers both sets of             centralized repository defining key
performance of the classic OLAP model.      needs. A set of cubes and dimensions                metrics and scorecards. The KPI
With Proactive Caching and advanced         defined in Analysis Services 2005 is                 framework in Analysis Services 2005
business intelligence capabilities,         referred to as a Unified Dimensional Model,          allows you to easily build balanced
Analysis Services moves into the realm      or UDM. The UDM is a central metadata               scorecard and other types of business
of real-time analytics while maintaining    repository defining business entities,               performance management applications.
MOLAP class performance.                    business logic, calculations, and metrics        ●  Translations. Translations provide a
Major enhancements in enterprise            that serves as the source for all reports,          simple, centrally-managed mechanism
capabilities including scalability,         spreadsheets, OLAP browsers, KPIs                   for storing and presenting analytic data
manageability, and productivity, soundly    and analytical applications.                        to users in their preferred languages.
position Analysis Services                  Using the powerful new Data Source View          ● MDX Scripts. MDX Scripts are the new
                                            feature, the UDM is mapped to a host of             mechanism for defining Calculated
                                                   heterogeneous back-end data                  Members, Named Sets, and Cell
                                                   sources allowing a complete and             Calculations.
                                                   integrated picture of the business        ● Business Intelligence Wizards. A set
                                                   regardless of the location of the data.     of easy to use wizards will help even
                                                   With the UDM’s friendly descriptions        the most novice user in modeling
                                                   of the business entities, navigation        some of the more complex business
                                                   hierarchies, multiple perspectives,          intelligence problems.
                                                   and even automatic translations to        ● Semi-Additive Measures. New
                                                   native languages the end-users will         measure aggregation type for advance
                                                   find it easy to explore the corporate        data modeling includes last-non-
                                                   business data.                              empty, last-child, first-child, average-
                                                                                               of-children and even by-account-type.
                                                  Proactive Caching
                                                  Proactive Caching enables the
                                                  combination of real-time updates
                                                  with MOLAP class performance
Web Services                                                                    the limitations of memory resident                                        application development environment
XML for Analysis (XML/A) is the native,                                         dimensions and the number of                                              supporting the full life cycle of the
standards-based protocol for communicat-                                        children members per parent.                                              project. Source control, versioning,
ing with the Analysis Services server. New                                      With XML/A-based communication                                            workstation isolation, embedded
kinds of applications are enabled and easy                                      protocol that is paired with greatly                                      debugging, and configuration
to develop – applications that integrate                                        optimized role based security Analysis                                    management are some of the benefits
analytics with operations in real time that                                     Services 2005 allows a UDM to                                             of the new BI Development Studio.
can access the data from any platform                                           handle thousands of users, enabling
and any language.                                                               enterprise scale BI applications using                             Additional Information
 ●  With XML/A as the native protocol,                                          web/middle tier or client/server                                   SQL Server is part of the Windows Server
    Analysis Services clients can be                                            architectures. Additionally, with                                  System — a comprehensive and integrated
    configured to have a zero footprint,                                         parallelized partition and dimension                               server infrastructure that simplifies the
    and each server is automatically a                                          processing Analysis Services can                                   development, deployment and operations
    web service.                                                                handle more data faster.                                           of flexible business solution.
●   A light-footprint Win32 layer is                                      ●     Manageability. By integrating the                                  For more information on SQL Server 2005,
    available for backward compatibility                                        management tools for the relational                                including Analysis Services Data Mining
    with tools that work with Analysis                                          engine and Analysis Services, the BI                               functionality, visit
    Services 2000 on OLE DB for OLAP,                                           administrator benefits from having a                                http://www.microsoft.com/sql/2005.
    ADOMD, and ADOMD.Net.                                                       single uniform environment for
                                                                                managing Analysis Services along
Enterprise Capabilities                                                         with SQL Server. With SQL
Analysis Services 2005 sets a new                                               Management Studio, administrators
standard for BI servers in enterprise                                           can easily script Analysis Services
scalability, manageability, and productivity:                                   objects and operations/tasks.
●   Scalability. Analysis Services 2005                                         Administrators can use a rich editor
    scales to the most demanding                                                for MDX and DMX queries. Profiler
    analytical and reporting applications.                                      can be used to trace, capture, and
    With Analysis Services’ new                                                 replay Analysis Services queries
    dimension architecture, UDM-enabled                                         and other commands. Multi-
    applications allow users to quickly                                         Instancing, enhanced backup and
    perform rich and intuitive adhoc                                            restore, synchronization of databases
    analysis using hundreds of                                                  across servers, and improved
    dimensions and hierarchies.                                                 fine-grained administrative
    Hierarchies, whether flat or multilevel,                                     permissions are some of the new
    make it easier for the users to                                             manageability tools available.
    navigate and query UDMs with                                          ●     Productivity. Integrated with Visual
    hundreds of millions of members.                                            Studio, Analysis Services intuitive
    The new architecture also removes                                           wizards and editors provide a true




This document is developed prior to the product’s release to manufacturing, and as such, we cannot guarantee that all details included herein will be exactly as what is found in the shipping product. The informa-
tion contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should
not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. The information represents the product at the
time this document was printed and should be used for planning purposes only. Information subject to change at any time without prior notice.
This document is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT.

Part No. 098-101996