ANALYSIS SERVICE TABULAR MOE IN MSSQL SERVER 2014 STANDART EDITION?

Catarina Knoedt 1 Reputation point
2021-11-03T22:19:20.54+00:00

HELLO EVERY ONE,

I have a problem and i need help.

WHEN I TRY TO INSTALL AN INSTANCE OF ANALYSIS SERVICE IN SQL SERVER VERSION 2014 STANDART EDITION TABULAR MODE IS DISABLED, THE ONLY OPTION IT BRINGS IS MULTIDIMENSIONAL. I TRIED WITH MICROSOFT BUT COULD NOT RESPOND TO ME CLEARLY. THE DOCUMENTATION DOES NOT REFERENCE THE STANDART VERSION CITES THE FEATURE IN GENERAL. , SOMEONE CAN ANSWER ME IF TABULAR MODE IS VALID IN VS STANDART OR ONLY IN ENTERPRISE AND BUSINESS INTELIGENCE. DEVELOPER IS NOT AN OPTION FOR ME.

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,244 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-11-04T02:10:26.693+00:00

    Hi @Catarina Knoedt ,

    Welcome to Microsoft Q&A!

    For SQL Server 2012 and 2014, Tabular mode Analysis Services is only available in Developer, Business Intelligence, and Enterprise editions.

    In SQL Server 2016 Standard Edition (plus more recent SQL versions), it is possible to install a Tabular mode instance of Analysis Services.

    For more information, please refer to this thread and Features Supported by the Editions of SQL Server 2014.

    Best regards,
    Carrin

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments