SSAS – SQL Server Analysis Service
Microsoft SQL Server Analysis Services or SSAS is an online analytical processing (OLAP), data mining and reporting tool in Microsoft SQL Server. We use Server Analysis to analyze and make sense of information spread out across multiple databases or in disparate tables. There are a number of services in SQL Server related to business intelligence and data warehousing including Integration Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities.
All the flavors of MOLAP, ROLAP and HOLAP to be used within the same model
SSAS – SQL Server Analysis Service Services
MOLAP, ROLAP, and HOLAP modes allow for storage of data in flexible ways.
No special processing
MOLAP and ROLAP
Processed or unprocessed, either way is ok
Microsoft Analysis Services supports different sets of APIs and object models for different operations and in different programming environments.
Wide variety of data
XML for analysis, OLE DB for OLAP, ADOMD, ADOMD.NET, and ADO.NET,
From high to low levels
DSO and AMO
Suitable for Windows and CLR platforms
Data definition language (DDL) and Data manipulation language (DML),
Many options, many ways to get the data
With the SQL Server Analysis Services platform we can build high performance analytical models both multidimensional and tabular that can be used for interactive data analysis, reporting, and visualization.
SQL Server provides a comprehensive analytical and modeling experience to support rapid solution prototyping and support for the largest enterprise-grade solutions.