Slowly Changing Dimensions in SQL Server 2005

This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.

Analysis Services

Handling Data Integrity Issues in Analysis Services 2005

Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.

Check List for Performance Optimisation in SQL Server Analysis Service 2005

This article is a step-by-step checklist to help ensure that you are obtaining the maximum performance possible from SQL Server Analysis Services.

Enabling Drillthrough in Analysis Services 2005

Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.

Accessing External Data Sources with Microsoft SQL Server Analysis Services 2005

This white paper covers a variety of client object models supported by Microsoft SQL Server Analysis Services when connecting to relational data sources. The example problems and solutions were gathered by members of the Analysis Services team while working with users of Analysis Services.

Writeback OLAP Data

Rethinking Analysis Services

Integrate SQL 2005, ASP.NET, Reporting Service and Analysis Services to rapidly develop and deploy a survey application for data entry and results analysis.

Problem connecting to SQL Server 2000 Analysis Services?

Connecting to SQL Server 2000 Analysis Services could lie in the memory settings. Get possible problems and solutions to connect to Analysis Services server.

Maximizing Attribute Relationship Aggregations in Changing Dimensions

When designing your SQL Server 2005 Analysis Services (SSAS) dimensions and related attributes—appropriately called attribute relationships—you should consider how changes in your dimension data will affect the underlying dimension aggregations and, in turn, processing and query performance.