Share via

SSAS related problem

NNJ 0 Reputation points
2023-10-11T02:30:17.4933333+00:00

New to SSAS. I have SQL Server, do I need to pay extra for ssas?

By the way, when I look up information, I see that Azure Analysis Services has similar functions. Which one should I choose?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-10-11T02:40:16.12+00:00

    Hi @NNJ

    First of all, there is No extra fees outside SQL Server for SSAS.

    It depends on what is your main purpose and hardware also.

    Azure Analysis Services is an on-cloud service, and SSAS is on premise.

    SSAS on-prem could have traditional multidimensional OLAP cube while on Azure Analysis Services we could only have tabular model now.

    Azure Analysis Services we could pay as used.

    Best regards,

    Percy Tang

    0 comments
  2. Olaf Helper 42,286 Reputation points
    2023-10-11T05:17:44.61+00:00

    I need to pay extra for ssas?

    The SQL Server license for Standard Edition covers the complete SQL Server technology stack and this means

    • relation database engine
    • Integration Services
    • Reporting Services
    • Analysis Services; in case of Standard "only" multi-dimensional mode, not tabular mode
    0 comments