Share via

SQL Server Analysis Services (SSAS)

  • Article

Overview

SQL Server Analysis Services (SSAS) is Microsoft's online analytical processing (OLAP) solution, and it is a SQL Server tool. OLAP solutions are central to business intelligence: using data about business operations to understand the business and make decisions that will drive future success in business. SSAS allows users to bring together data from multiple relational databases into a central location and then presents that data in a fashion that makes it easy for the users to query the data, view the data at various levels of detail, and perform advanced calculations against the data, all with the objective of deriving useful information from the millions or billions of transactions that occur in a business on a daily basis. SSAS accomplishes this by structuring and presenting data using the [[articles: Unified Dimensional Model]] (UDM).

In addition to its OLAP functionality, Analysis Services provides an in-memory tabular model that is useful for fast prototyping and very fast queries.

Analysis Services Wiki Articles

Please feel welcome to add links to the following sections, create new articles, or recommend articles that can be referenced from this Wiki. Articles included here should touch on at least one of these subjects: queries using MDX, DMX, and XMLA; multidimensional modeling and tabular modeling, using either UDM and BISM; effective design of dimensions, measures and other parts of a cube; troubleshooting, performance tuning, and monitoring of  solutions built using MOLAP/HOLAP/ROLAP; business cases and real-life scenarios for SSAS solutions using both cube and tabular models; use of AMO and interfaces such as OLEDB to programmatically work with multidimensional or data mining objects; data mining using SQL Server Analysis Services.

Dimensional Modeling 101

[[Unified Dimensional Model]]

Security

  • [[Role (OLAP)]]

Tabular Models

  • DAX Survival Guide

    link

Performance

We've moved all the SSAS performance information to a new page so that we can provide links to SQL CAR articles, white papers, and more.

http://social.technet.microsoft.com/wiki/contents/articles/23665.analysis-services-ssas-performance-and-monitoring-tips.aspx

Administration and Monitoring

Tools

Query and DDL Languages

Data Mining

More data mining tips and articles are available from the data mining Wiki page.

http://social.technet.microsoft.com/wiki/contents/articles/13672.data-mining-and-predictive-analytics.aspx

See Also

 

Other Languages

This article is also available in the following languages:

Brazilian Portuguese (pt-BR)

German (de-DE)