Analysis Services

Find techniques you can use to operate and maintain a SQL Server 2000 Analysis Services data warehouse.

Get techniques you can use to optimize query responsiveness and processing performance in SQL Server 2000 Analysis Services.

Learn about key technical differences between the 32-bit and 64-bit versions of Analysis Services, and whether these advantages make migrating to SQL Server 2000 (64-bit) right for you.

Get best practices for building an analytical application leveraging both SQL Server 2000 Analysis Services and the Teradata Database for a hybrid online analytical processing (HOLAP), multidimensional OLAP (MOLAP), or relational OLAP (ROLAP) solution.

Learn about the installation, implementation, and behavior of HTTP connectivity in SQL Server 2000 Analysis Services Service Pack 3 (SP3).

Learn how you can use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for SQL Server 2000 Analysis Services.

Get the updated samples for SQL Server 2000 Service Pack 3 (SP3), including updated versions of the samples that shipped with SQL Server 2000 Analysis Services and a new connection pooling sample.

Drillthrough is an important part of working with OLAP data. Get an overview of the objects, methods, and procedures of a code sample that illustrates one way of using drillthrough from the PivotTable component.

Discover the improvements in cell writeback, a key feature of SQL Server 2000 Analysis Services, and learn how to optimize cell writeback performance.

Learn the practical definition of real-time OLAP as implemented in Microsoft SQL Server 2000 Analysis Services and get technical information and guidelines for the use of this powerful feature.

This MSDN article follows the design and implementation of a series of test scenarios that include building and querying cubes using SQL Server 2000 Analysis Services.

Using Microsoft SQL Server 2000 Analysis Services, you can easily create OLAP cubes and dimensions from a variety of data sources. SQL Server 2000 Analysis Services allows you to model a rich set of dimension types. This paper describes how and when to use the variety of dimension types available in SQL Server 2000 Analysis Services.

Find out which OLAP product best fits your needs. Review this white paper to learn about the differences between SQL Server 2000 Analysis Services, IBM DB2 OLAP Server 8.1, and Hyperion Essbase 6.5.

This white paper explains the Distinct Count aggregate function and focuses on a performance study using Analysis Services and SQL Server Accelerator for Business Intelligence.

Read this MSDN article to learn more about the differences between OLTP and OLAP.

Visit MSDN to explore the components offered with SQL Server 2000. Find out how to use these features to transform online transaction processing (OLTP) data into OLAP data and make the OLAP information available to decision makers.

Download the OLAP Manager Add-In Kit which provides the functionality to perform tasks that previously required custom programming using DSO.

Visit the MSDN site to learn more about the Decision Support Objects (DSO) library, which supports a COM object model providing control of meta data in Analysis Services. This article provides a better understanding of the basics of using DSO within a custom application.