Microsoft SQL Server Analysis Services

Microsoft SQL Server Analysis Services (SSAS) is the OLAP component of the SQL Server suite. With Analysis Services, it is possible to quickly and easily slice and dice the information in your data warehouse. Storing the data of your warehouse in an OLAP architecture provides a faster and more intuitive way of accessing that data. In Analysis Services, as in any OLAP architecture, everything is based around a cube.

The cube holds the:

  • Measures in one or more measure groups
  • Dimensions providing the necessary information on the measures
  • Additional calculated members and measures
  • Actions, translations, perspectives
  • And many more ...