Tabular VS Multidimensional - why the latter are not supported in Azure Analysis Services

Lolipooop 180 Reputation points
2023-10-07T12:32:50.9166667+00:00

I want to understand the differences between both and why the multidimensional models are not supported in AAS?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 16,071 Reputation points
    2023-10-07T12:38:33.07+00:00

    To understand the differences, I recommend that you consult the documentation: https://learn.microsoft.com/en-us/analysis-services/comparing-tabular-and-multidimensional-solutions-ssas?view=asallproducts-allversions

    Regarding the "why", I saw many professionals just guessing since tabular models are designed to leverage in-memory columnar storage (we talk about modern data processing with the rise of cloud products)

    They offer faster query performance and they are easy when it comes to integration with other Azure services.

    I leave you with some links :

    https://stackoverflow.com/questions/76984816/why-are-multidimensional-models-not-supported-in-azure-analysis-services

    https://stackoverflow.com/questions/61566121/what-is-the-best-approach-between-aas-tabular-model-or-ssas-multidimensional-in


0 additional answers

Sort by: Most helpful