SSAS Interview Question: Difference Between Measure and Dimension

In SSAS (SQL Server Analysis Services), a measure is a numerical value that can be aggregated for analysis, such as sales revenue or quantity sold. Measures are typically numeric and represent the key performance indicators (KPIs) in a data cube.

On the other hand, a dimension in SSAS is a categorical attribute that provides context or grouping for measures. Dimensions are used for slicing and dicing data, organizing it into meaningful hierarchies, and adding descriptive metadata to the analysis.

Therefore, the main difference between a measure and a dimension in SSAS is that measures are numerical values used for analysis and aggregation, while dimensions are categorical attributes that provide context and organization to the measures.