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 a rich set of data mining features that allow users to build advanced statistical models of their data and use those models to categorize data and make predictions based on that data.
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
This article is also available in the following languages:
Richard Mueller edited Revision 31. Comment: Fixed HTML <h> tags so header lines show in TOC
Ed Price - MSFT edited Revision 28. Comment: Added tag. Added TOC.
Fernando Lugão Veltem edited Revision 26. Comment: added security session
Horizon_Net edited Revision 25. Comment: added link to German version
Fernando Lugão Veltem edited Revision 24. Comment: added portuguese version
Jeannine Takaki edited Revision 22. Comment: added description of scope for articles (for search); spell check
Jeannine Takaki edited Revision 21. Comment: added link to DM stored procedures articles; fixed extra H1
Jeannine Takaki edited Revision 12. Comment: Added subheadings and some new links.
Ed Price MSFT edited Revision 4. Comment: Added Wiki Articles and See Also sections.