Analysis Services features supported by SQL Server editions

APPLIES TO:yesSQL Server Analysis Services (starting with 2016)noAzure Analysis Services

This topic provides details of features supported by the different editions of SQL Server 2016 Analysis Services. For features supported by Evaluation and Developer editions, see Enterprise edition.

Analysis Services (servers)

Feature Enterprise Standard Web Express with Advanced Services Express with Tools Express Developer
Scalable shared databases Yes Yes
Backup/Restore & Attach/Detach databases Yes Yes Yes
Synchronize databases Yes Yes
Always On 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
In-memory storage mode Yes Yes Yes
DirectQuery storage mode Yes 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 Yes
Writeback cells Yes Yes Yes
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 2 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
Direct writeback 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 Standard edition supports linking measures and dimensions within the same database, but not from other databases or instances.

Power Pivot for SharePoint

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

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

See also

Product Specifications for SQL Server 2016
Installation for SQL Server