SSAS Feature Matrix: Tabular vs Multidimensional Changes to the feature matrix as of SSAS 2017 CTP 2.1 (1400 compatibility level) include the following: Drillthrough now supported via Detail Rows Expressions Ragged Hierarchies now supported via Hide Blank Members Object Level Security (OLS) on tables and columns to deny metadata access A row (feature) has been added to the matrix for Display Folders For 2016 (1200 CL) features the corresponding 2017 (CTP 2.1) column simply ‘Supported’ As of CTP 2.0, Tabular mode is now the default installation of SSAS. Many other features and improvements specific to Tabular mode that are not included in this matrix Get Data Experience (M), DAX Editor in SSDT, DAX and TMSL Support in SSMS, DMV improvements, new DAX functions and operators, encoding hints and more. See for more details. Given alignment with Power BI (Get Data/M Expressions) and on other features, importing Power BI Desktop to SSAS 2017 likely available soon Bidirectional cross-filtering has a broader application than many-to-many relationships. See the for more details. Feature Detail Multidimensional Tabular 2012-2014 Tabular 2016 Tabular 2017 (CTP 2.1) Many to Many One of most important Supported Complex DAX Bidirectional Supported Relationships features in Functions to control Filtering Relationships Multidimensional and filter context frequently Can also use used. CROSSFILTER function NUMA Awareness Efficiently retrieve data Supported Not Supported Available with SP1: Supported stored on multiple separate job on numa nodes each of four or more NUMA nodes. (Not enabled with less than 4 nodes).
SSAS Feature Matrix: Tabular vs Multidimensional Changes to the feature matrix as of SSAS 2017 CTP 2.1 (1400 compatibility level) include the following: Drillthrough now supported via Detail Rows Expressions Ragged Hierarchies now supported via Hide Blank Members Object Level Security (OLS) on tables and columns to deny metadata access A row (feature) has been added to the matrix for Display Folders For 2016 (1200 CL) features the corresponding 2017 (CTP 2.1) column simply ‘Supported’ As of CTP 2.0, Tabular mode is now the default installation of SSAS. Many other features and improvements specific to Tabular mode that are not included in this matrix Get Data Experience (M), DAX Editor in SSDT, DAX and TMSL Support in SSMS, DMV improvements, new DAX functions and operators, encoding hints and more. See for more details. Given alignment with Power BI (Get Data/M Expressions) and on other features, importing Power BI Desktop to SSAS 2017 likely available soon Bidirectional cross-filtering has a broader application than many-to-many relationships. See the for more details. Feature Detail Multidimensional Tabular 2012-2014 Tabular 2016 Tabular 2017 (CTP 2.1) Many to Many Relationships One of most important features in Multidimensional and frequently used. Supported Complex DAX Functions to control filter context Bidirectional Filtering Relationships Can also use CROSSFILTER function Supported NUMA Awareness Efficiently retrieve data stored on multiple numa nodes Supported Not Supported Available with SP1: separate job on each of four or more NUMA nodes. (Not enabled with less than 4 nodes). Supported
ssas-feature-matrix-ssas-2017-ctp-2-1.docx