Go Green One tree
One life

What Is SSAS (SQL Server Analysis Services) Explained In 200 Words


December 24, 2019


June 29th, 2023

SQL Server Analysis Services (SSAS) is an Online Analytical Processing (OLAP) and data mining tool in Microsoft SQL Server.

SSAS creates cubes using data from data marts / data warehouse for in-depth and quicker data analysis.

Installed as an on-premises server instance, SSAS supports tabular models at all compatibility levels, multidimensional models, data mining, and Power Pivot for SharePoint.

SSAS helps build Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP) and Hybrid OLAP (HOLAP) architectures.

Its architectural view depends on a 3-tier architecture, consisting of RDBMS, SSAS and Client.

Process Steps Using SSAS

  • Read data from a dimensional model
  • Configure a schema in BI development studio
  • Create dimensions, measures and cubes from the schema
  • Fine tune cute as per needs
  • Implement the cube


Major Terminologies

Data source, data source view, cube, dimension table, dimension, fact table, level, measure, schema etc.

Types Of SSAS Models

  • Multidimensional data model
  • Tabular model


  • Can be used with different wizards
  • Flexible data model creation
  • Permits working on client-server mode or offline mode
  • Offers backward compatibility at the API level
  • Gives dynamic structure, Ad hoc report, Shared metadata, and security features

Don’t miss out on our detailed article: All About SSAS In An Easy Manner


SPEC INDIA, as your single stop IT partner has been successfully implementing a bouquet of diverse solutions and services all over the globe, proving its mettle as an ISO 9001:2015 certified IT solutions organization. With efficient project management practices, international standards to comply, flexible engagement models and superior infrastructure, SPEC INDIA is a customer’s delight. Our skilled technical resources are apt at putting thoughts in a perspective by offering value-added reads for all.

Delivering Digital Outcomes To Accelerate Growth
Let’s Talk