SQL Server Analysis Services (SSAS)

Microsoft's portal for SQL Server Analysis Services (SSAS). This site aggregates the best content we can find for SSAS including virtual labs, tutorials, videos, training, troubleshooting, how to, getting started, blogs, news, and more.

What is SQL Server Analysis Services (SSAS) ?

Learning Center Resources | What's New | Product Overview

Learn SQL Server Analysis Services (SSAS)

New to SSAS? Start Here | Tutorials | Documentation

SQL Server Analysis Services (SSAS) Highlights

SQL Server – Analysis Services Multidimensional Data (SSAS)

The Many Benefits of Money…Data Type! Our initial reason for looking at the money data type can be found within the Precision Considerations for Analysis Services Users white paper. In this white paper, we provide extensive examples of the types of precision issues when your SQL relation... more

Analysis Services Distinct Count Optimization Using Solid State Devices To expand on the distinct count optimization techniques provided in the Analysis Services Distinct Count Optimization white paper, this technical note shows how using solid state devices (SSDs) can improve distinct count measures. We recount the expe... more

Data Warehouse Performance Data warehouses are characterized by queries that scan larger numbers of rows, large ranges of data and may return relatively large results for the purposes of analysis and reporting. Most relational technologies are not tuned to deal with the large-... more

BI Service Applications in SharePoint 2010 – Authentication (Classic vs. Claims) and Identity Delegation (Kerberos) – Part 4 This post is part of a series of posts describing the authentication methods supported by the SharePoint 2010 Business Intelligence service applications. Please see Part 1 for an overview of this series of posts. This post describes my claims-mode we... more