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 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.
Please feel welcome to add links to the following sections, create new articles, or 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.
Unified Dimensional Model
DAX Survival Guide
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.
More data mining tips and articles are available from the data mining Wiki page.
This article is also available in the following languages: