正文

Analysis Services features supported by SQL Server editions

IP云
IP云V管理员/5 阅读
09/19
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

Analysis Services (servers)

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Scalable shared databasesYes     Yes
Backup/Restore & Attach/Detach databasesYesYes    Yes
Synchronize databasesYes     Yes
Always On failover cluster instancesYes

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)YesYes    Yes

Tabular models

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
HierarchiesYesYes    Yes
KPIsYesYes    Yes
PerspectivesYes     Yes
TranslationsYesYes    Yes
DAX calculations, DAX queries, MDX queriesYesYes    Yes
Row-level securityYesYes    Yes
Multiple partitionsYes     Yes
In-memory storage modeYesYes    Yes
DirectQuery storage modeYes     Yes

Multidimensional models

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Semi-additive measuresYesNo 1    Yes
HierarchiesYesYes    Yes
KPIsYesYes    Yes
PerspectivesYes     Yes
ActionsYesYes    Yes
Account intelligenceYesYes    Yes
Time intelligenceYesYes    Yes
Custom rollupsYesYes    Yes
Writeback cubeYesYes    Yes
Writeback dimensionsYes     Yes
Writeback cellsYesYes    Yes
DrillthroughYesYes    Yes
Advanced hierarchy types (parent-child and ragged hierarchies)YesYes    Yes
Advanced dimensions (reference dimensions, many-to-many dimensions)YesYes    Yes
Linked measures and dimensionsYesYes 2    Yes
TranslationsYesYes    Yes
AggregationsYesYes    Yes
Multiple partitionsYesYes, up to 3    Yes
Proactive cachingYes     Yes
Custom assemblies (stored procedures)YesYes    Yes
MDX queries and scriptsYesYes    Yes
DAX queriesYesYes    Yes
Role-based security modelYesYes    Yes
Dimension and cell-level securityYesYes    Yes
Scalable string storageYesYes    Yes
MOLAP, ROLAP, and HOLAP storage modelsYesYes    Yes
Binary and compressed XML transportYesYes    Yes
Push-mode processingYes     Yes
Direct writebackYes     Yes
Measure expressionsYes     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

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
SharePoint farm integration based on shared service architectureYes     Yes
Usage reportingYes     Yes
Health monitoring rulesYes     Yes
Power Pivot galleryYes     Yes
Power Pivot data refreshYes     Yes
Power Pivot data feedsYes     Yes

Data Mining

Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Standard algorithmsYesYes    Yes
Data mining tools (Wizards, Editors, Query Builders)YesYes    Yes
Cross validationYes     Yes
Models on filtered subsets of mining structure dataYes     Yes
Time series: Custom blending between ARTXP and ARIMA methodsYes     Yes
Time series: Prediction with new dataYes     Yes
Unlimited concurrent DM queriesYes     Yes
Advanced configuration & tuning options for data mining algorithmsYes     Yes
Support for plug-in algorithmsYes     Yes
Parallel model processingYes     Yes
Time series: cross-series predictionYes     Yes
Unlimited attributes for association rulesYes     Yes
Sequence predictionYes     Yes
Multiple prediction targets for naïve Bayes, neural network and logistic regressionYes     Yes