Muokkaa

Jaa


Analysis Services features supported by SQL Server edition

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

This article describes features supported by different editions of SQL Server 2016, 2017, 2019, 2022 Analysis Services. Evaluation edition supports Enterprise edition features.

Analysis Services (servers)

Feature Enterprise Standard Web Express with Advanced Services Express with Tools Express Developer
Scalable shared databases Yes Yes
Backup/Restore Yes Yes Yes
Attach/Detach databases Yes Yes
Synchronize databases Yes Yes
Failover cluster instances Yes

Number of nodes is the operating system maximum
Yes

Support for 2 nodes
Yes

Number of nodes is the operating system maximum
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL, TMSL) Yes Yes Yes

Tabular models

Feature Enterprise Standard Web Express with Advanced Services Express with Tools Express Developer
Hierarchies Yes Yes Yes
KPIs Yes Yes Yes
Perspectives Yes Yes
Translations Yes Yes Yes
DAX calculations, DAX queries, MDX queries Yes Yes Yes
Row-level security Yes Yes Yes
Multiple partitions Yes Yes
Calculation groups Yes (beginning with SQL Server 2019) Yes (beginning with SQL Server 2019) Yes (beginning with SQL Server 2019)
Query interleaving Yes (beginning with SQL Server 2019) Yes (beginning with SQL Server 2019) Yes (beginning with SQL Server 2019)
Many-to-many relationships Yes (beginning with SQL Server 2019) Yes (beginning with SQL Server 2019) Yes (beginning with SQL Server 2019)
In-memory storage mode Yes Yes Yes
DirectQuery mode Yes Yes (beginning with SQL Server 2019) Yes

Multidimensional models

Feature Enterprise Standard Web Express with Advanced Services Express with Tools Express Developer
Semi-additive measures Yes No 1 Yes
Hierarchies Yes Yes Yes
KPIs Yes Yes Yes
Perspectives Yes Yes
Actions Yes Yes Yes
Account intelligence Yes Yes Yes
Time intelligence Yes Yes Yes
Custom rollups Yes Yes Yes
Writeback cube Yes Yes Yes
Writeback dimensions Yes 2 Yes 2
Drillthrough Yes Yes Yes
Advanced hierarchy types (parent-child and ragged hierarchies) Yes Yes Yes
Advanced dimensions (reference dimensions, many-to-many dimensions) Yes Yes Yes
Linked measures and dimensions Yes Yes 3 Yes
Translations Yes Yes Yes
Aggregations Yes Yes Yes
Multiple partitions Yes Yes, up to 3 Yes
Proactive caching Yes Yes
Custom assemblies (stored procedures) Yes Yes Yes
MDX queries and scripts Yes Yes Yes
DAX queries Yes Yes Yes
Role-based security model Yes Yes Yes
Dimension and cell-level security Yes Yes Yes
Scalable string storage Yes Yes Yes
MOLAP, ROLAP, and HOLAP storage models Yes Yes Yes
Binary and compressed XML transport Yes Yes Yes
Push-mode processing Yes Yes
Measure expressions Yes Yes

[1] The LastChild semi-additive measure is supported in Standard edition, but other semi-additive measures, such as None, FirstChild, FirstNonEmpty, LastNonEmpty, AverageOfChildren, and ByAccount, are not. Additive measures, such as Sum, Count, Min, Max, and non-additive measures (DistinctCount) are supported on all editions.

[2] Writeback dimensions are discontinued in SQL Server Analysis Services 2019 and later.

[3] Standard edition supports linking measures and dimensions within the same database, but not from other databases or instances.

Power Pivot for SharePoint

Important

Power Pivot mode is Discontinued in SQL Server Analysis Services 2022. To learn more, see What's new in SQL Server 2022 Analysis Services - Discontinued features.

Feature Enterprise Standard Web Express with Advanced Services Express with Tools Express Developer
SharePoint farm integration based on shared service architecture Yes Yes
Usage reporting Yes Yes
Health monitoring rules Yes Yes
Power Pivot gallery Yes Yes
Power Pivot data refresh Yes Yes
Power Pivot data feeds Yes Yes

Data Mining

Important

Data mining is Discontinued in SQL Server Analysis Services 2022. To learn more, see What's new in SQL Server 2022 Analysis Services - Discontinued features.

Feature Name Enterprise Standard Web Express with Advanced Services Express with Tools Express Developer
Standard algorithms Yes Yes Yes
Data mining tools (Wizards, Editors, Query Builders) Yes Yes Yes
Cross validation Yes Yes
Models on filtered subsets of mining structure data Yes Yes
Time series: Custom blending between ARTXP and ARIMA methods Yes Yes
Time series: Prediction with new data Yes Yes
Unlimited concurrent DM queries Yes Yes
Advanced configuration & tuning options for data mining algorithms Yes Yes
Support for plug-in algorithms Yes Yes
Parallel model processing Yes Yes
Time series: cross-series prediction Yes Yes
Unlimited attributes for association rules Yes Yes
Sequence prediction Yes Yes
Multiple prediction targets for naïve Bayes, neural network and logistic regression Yes Yes