Analysis Services features supported by SQL Server editions

时间:2023-03-08 16:25:23
Analysis Services features supported by SQL Server editions

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