Gartner Research

Microsoft SQL Server 2000 Analysis Services Business Intelligence

Published: 01 August 2003

ID: G0093178

Analyst(s): Alan H. Tiedrich

Summary

Analysis Services, bundled with SQL Server 2000, is Microsoft's OLAP applications platform. With Microsoft's (and third-party) client and development tools to support it, it has become a mainstream player.

Table Of Contents
  • Corporate Headquarters
  • Overview
  • Analysis
    • Analysis Services Data Models
    • End-User Access — PivotTable Service
    • Calculation and Analytic Functions
    • XML/A Support
    • Data-Mining Functionality
    • Programmability of Functionality
  • Pricing
    • GSA Pricing
  • Competitors
  • Strengths
    • Performance and Scalability
    • Partitioned, Virtual and Linked Cubes
    • Flexible Data Storage Options — ROLAP, MOLAP and HOLAP
    • Open Database Architecture
    • Low Cost of Entry
    • Third-Party Tools Support
    • Third-Party Application Development Support
    • Support From Other Microsoft Products
    • Programmability Support
    • Ease of Use for IT Personnel
    • Security Model
    • Data Mining
  • Limitations
    • Unix/Linux Support
    • Support for OLAP Servers
    • Integrated Product Family
    • Java Support
    • Application Development
    • Data Mining
    • Recommended Gartner Research
  • Insight

©2020 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.

Already have a Gartner Account?

Purchase this Document

To purchase this document, you will need to register or sign in above

Become a client

Learn how to access this content as a Gartner client.