Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama Fabraic, Power BI, agus SQL is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuNí thacaítear leis an mbrabhsálaí seo a thuilleadh.
Uasghrádú go Microsoft Edge chun leas a bhaint as na gnéithe is déanaí, nuashonruithe slándála, agus tacaíocht theicniúil.
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.
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 |
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 |
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.
Tábhachtach
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 |
Tábhachtach
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 |
Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama Fabraic, Power BI, agus SQL is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuOiliúint
Deimhniú
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Doiciméadúchán
What's new in SQL Server Analysis Services
Learn about new features and improvements in the most recent versions of SQL Server Analysis Services (SSAS).
SQL Server Analysis Services overview
Describes SQL Server Analysis Services.
Comparing Analysis Services tabular and multidimensional models
Describes the differences between Analysis Services multidimensional and tabular model solutions.