WordPress.com



SSAS Feature Matrix: Tabular vs MultidimensionalChanges to the feature matrix as of SSAS 2017 CTP 2.1 (1400 compatibility level) include the following:Drillthrough now supported via Detail Rows ExpressionsRagged Hierarchies now supported via Hide Blank MembersObject Level Security (OLS) on tables and columns to deny metadata accessA row (feature) has been added to the matrix for Display FoldersFor 2016 (1200 CL) features the corresponding 2017 (CTP 2.1) column simply notes ‘Supported’ Notes: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 matrixGet 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 What’s New in SSAS 2017 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 soonBidirectional cross-filtering has a broader application than many-to-many relationships. See the official whitepaper for more details. FeatureDetailMultidimensionalTabular 2012-2014Tabular 2016Tabular 2017 (CTP 2.1)Many to Many RelationshipsOne of most important features in Multidimensional and frequentlyused. SupportedComplex DAX Functions to control filter contextBidirectional Cross- Filtering RelationshipsCan also use CROSSFILTER function AwarenessEfficiently retrieve data stored on multiple numa nodesSupportedNot SupportedAvailable with SP1: separate job queue on each of four or more NUMA nodes. (Not enabled with less than 4 nodes). SupportedWritebackEnd user can write values to the SSASdatabase. (e.g. Budget values)SupportedNot SupportedNot SupportedNot SupportedTranslationsMetadata of model can appear in different languages for users with different localeson their desktopsSupportedNot SupportedSupported with 1200 compatibility level modelsTranslated Metadata to JSON file and import Dim Security on MeasuresAccess to a single measure can be granted or deniedSupportedNot SupportedNot SupportedObject Level Security (OLS) to supplement existing Row Level Security (RLS). Denies visibility to metadata of columns and tables such that these objects can’t be discovered. Cell SecurityAccess to individual cells can be granted or deniedSupportedNot SupportedNot SupportedObject Level Security (OLS) to supplement existing Row Level Security (RLS). Denies visibility to metadata of columns and tables such that these objects can’t be discovered. Ragged HierarchiesIn Multidim, a user hierarchy can be made to look something likea parent/child hierarchy by hiding members if certain conditions are met.SupportedNot SupportedNot SupportedCan set Hide Members property for a user hierarchy to ‘Hide Blank Members’.Role-Playing DimensionsDesign and process a dim once, then appear many times in the model with different names and different relationships to measure groups. (role-playing dims in Multidim)Supported DAX Function:USERELATIONSHIP Calculated Tables Added as optionDAX Function:USERELATIONSHIP Calculated TablesDAX Function:USERELATIONSHIP Scoped Assignments andUnary OperatorsAdvanced Calculation functionality present in MDX. SupportedNot SupportedNot SupportedNot SupportedParent/Child HierarchiesSpecial type of self-join hierarchy in Multidimensional dims.SupportedDAX PATH Functions:, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTHDAX PATH Functions:, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTHDAX PATH Functions:, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTHDisplay FoldersOrganize measureSupportedBIDS Helper Add-in for 1100 and 1103 CL Tabular ModelsCreate display folders for measures and columns in SSDTSupportedDrillthroughClick a cell to see detail level data aggregated to return that value. Supported*Can specific which columns are retrieved from drilltrhoughDefault: Every column from single tableAlternative:BIDS Helper Add-in oredit the XMLA definition of modelmanuallyBIDS Helper to be built into VS 2015 SSDT (Preview) *Currently no support for 1200 modelsCan drillthrough on multi-select with Excel 2016 and SSAS 2016 (or Excel 2016 Data Model)Detail Rows Expression property for measures can define specific columns and rows returned to the end user. (e.g. two columns from customer dimension, 3 columns from fact table)The filter context of the measure in the report is respected.Can also define a default detail rows expression for all measures of a given fact table. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download