In Multidim, a user Supported Not Supported Not Supported Can set Hide Members Ragged Hierarchies hierarchy can be made property for a user to look something like hierarchy to Blank ‘Hide a hierarchy Members’. by hiding members if certain conditions are met. Role-Playing Design and process a Supported DAX Function: Calculated Tables Calculated Tables Dimensions dim once, then appear USERELATIONSHIP Added as option many times DAX Function: in the model with DAX Function: USERELATIONSHIP different names and USERELATIONSHIP different relationships to measure groups. (role-playing dims in Multidim) Scoped Assignments Advanced Calculation Supported Not Supported Not Supported Not Supported and functionality present in Unary Operators MDX. Special type of self-join Supported DAX PATH Functions: DAX PATH Functions: DAX PATH Functions: Parent/Child Hierarchies hierarchy in Multidimensional dims. PATH, PATHCONTAINS, PATH, PATHCONTAINS, PATH, PATHCONTAINS, PATHITEM, PATHITEM, PATHITEM, PATHITEMREVERSE, PATHITEMREVERSE, PATHITEMREVERSE, PATHLENGTH PATHLENGTH PATHLENGTH Display Folders Organize measure Supported BIDS Helper Add-in for Create display folders Supported 1100 and 1103 CL for measures and Tabular Models columns in SSDT
Ragged Hierarchies In Multidim, a user hierarchy can be made to look something like a hierarchy by hiding members if certain conditions are met. Supported Not Supported Not Supported Can set Hide Members property for a user hierarchy to ‘Hide Blank Members’. Role-Playing Dimensions Design 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 option DAX Function: USERELATIONSHIP Calculated Tables DAX Function: USERELATIONSHIP Scoped Assignments and Unary Operators Advanced Calculation functionality present in MDX. Supported Not Supported Not Supported Not Supported Parent/Child Hierarchies Special type of self-join hierarchy in Multidimensional dims. Supported DAX PATH Functions: PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH DAX PATH Functions: PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH DAX PATH Functions: PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH Display Folders Organize measure Supported BIDS Helper Add-in for 1100 and 1103 CL Tabular Models Create display folders for measures and columns in SSDT Supported
ssas-feature-matrix-ssas-2017-ctp-2-1.docx