Name Type Description ID unsignedLong A reference to the object. PerspectiveTableID unsignedLong An ID-based reference to a PerspectiveTable object. MeasureID unsignedLong An reference to a Measure object. ModifiedTime dateTime The time that the object was last modified. Role Object The Role object defines a set of user principals for whom security are applied. It is a child of a Model object. The Role object has the following properties. Name Type Description ID unsignedLong A reference to the object. ModelID unsignedLong An ID-based reference to a Model object. Name string The name of the object. Description string The description of the object. ModelPermission enumeration The level of access for this role. The possible values are as follows: None (1) - The role has no access to the Read (2) - The role can read metadata and data of the Model. ReadRefresh (3) - The role has read and refresh permission. Refresh (4) - The role can refresh the data and calculations in the Model. Administrator (5) - The role can administer the ModifiedTime dateTime The time that the object was last modified. RoleMembership Object The RoleMembership object defines a user principal that belongs to the Role object. It is a child of a Role object. The RoleMembership object has the following properties. Name Type Description ID unsignedLong A reference to the object. RoleID unsignedLong An ID-based reference to a Role object. MemberName string The security name that identifies the user or group of the member.
Expression properties and clarified which properties used a provider or structured data source. Object definitions of the ShowAsVariationsOnly, IsPrivate, and DefaultDetailRowsDefinitionID properties. Column Object Added the definition of the EncodingHint property. Major Partition Object Added the definitions if the RetainDataTillForceCalculate property and the M and Entity values of the Type property. Major Measure Object Added the description of the DetailRowsDefinitionID property. Major Hierarchy Object Added the description of the HideMembers property. Major Annotation Object Added data type values TM_TYPEID_Variation, TM_TYPEID_Expression, and TM_TYPEID_ColumnPermission and removed the TM_TYPEID_Annotation and TM_TYPEID_ObjectTranslation values for the ObjectType property. ObjectTranslation Object Added TM_TYPEID_Variation and TM_TYPEID_Expression and removed TM_TYPEID_DataSource, TM_TYPEID_AttributeHierarchy, TM_TYPEID_Partition, TM_TYPEID_Relationship, TM_TYPEID_Annotation, TM_TYPEID_Culture, TM_TYPEID_ObjectTranslation, TM_TYPEID_LinguisticMetadata, TM_TYPEID_PerspectiveTable, TM_TYPEID_PerspectiveColumn, TM_TYPEID_PerspectiveHierarchy, TM_TYPEID_PerspectiveMeasure, TM_TYPEID_RoleMembership, and TM_TYPEID_TablePermission for the ObjectType property. Major TablePermission Object Added MetadataPermission description for SQL Server 2017. Major Variation Object Added new section. Expression Object Added section for SQL Server 2017. Major
ColumnPermission Object Added section for SQL Server 2017. Major DetailRowsDefinition Object Added section for SQL Server 2017. Major Discover 10052223 : Defined 'restriction' as used in Discover request types. Minor Columns description of the DataAccessOptions element for SQL Server 2017. Major 3.1.5.1.1.1.2.1 Columns Added information about the DefaultMeasureID column. Major Columns Added the definitions of types ConnectionDetails, Options, and Credential properties to the XSD and clarified which column objects are allowed to have restrictions. Major 3.1.5.1.1.2.2.1 Columns the ContextExpression element for SQL Server 2017. Major Columns information about the ShowAsVariationsOnly, IsPrivate, and DefaultDetailRowsDefinitionID columns. Major Additional Restrictions Added information about the EncodingHint column. Columns Added information about the RetainDataTillForceCalculate column. Major Columns Added information about the DetailRowsDefinitionID column. Major Columns Added the definition of the HideMembers property to the XSD. Major Columns Added the MetadataPermission element for SQL Server 2017. Major TMSCHEMA_VARIATIONS Added section. Major Request Body Added section. Major Response Body Added section. Major Columns Added section. Major Additional Restrictions Added section. TMSCHEMA_EXTENDED_PROPERTIES Added section. Major
Request Body Added section. Major Response Body Added section. Major Columns Added section. Major Additional Restrictions Added section. TMSCHEMA_EXPRESSIONS Added section for SQL Server 2017. Major TMSCHEMA_COLUMN_PERMISSIONS Added section for SQL Server 2017. Major Request Body Added section for SQL Server 2017. Major Response Body Added section for SQL Server 2017. Major Columns Added section for SQL Server 2017. Major Additional Restrictions Added section for SQL Server 2017. Major TMSCHEMA_DETAIL_ROWS_DEFINITIONS section for SQL Server 2017. Major Request Body Added section for SQL Server 2017. Major Response Body Added section for SQL Server 2017. Columns Added section for SQL Server 2017. Major Additional Restrictions Added section for SQL Server 2017. Major Tabular Metadata Commands the Variations, ExtendedProperties, Expressions, ColumnPermissions, and DetailRowsDefinitions elements to the TabularCommandType XSD and the ConnectionDetails, Options, Credential, and ContextExpression elements to the rowset example. Major Create Tabular Metadata statement that the Create Tabular Metadata command does not support creation of the Model object. Create DataSources Added the definitions of the ConnectionDetails, Options, and Credential properties. Major
3.1.5.2.1.1.1.1 Create DataSources the ContextExpression element information for SQL Server 2017. Major Create Tables Added the ShowAsVariationsOnly and IsPrivate elements. Major Create Columns Added the EncodingHint element. Major Create Partitions Added the DataView and RetainDataTillForceCalculate elements. Major Create Hierarchies Added the definition of the HideMembers property to the XSD. major Create Annotations Added the ObjectID.Variation, ObjectID.Expression, and ObjectID.ColumnPermission elements. Major Create ObjectTranslations information about ObjectID.Role; and removed information about the following elements: ObjectID.DataSource, ObjectID.Partition, ObjectID.Relationship, ObjectID.Culture, ObjectID.PerspectiveTable, ObjectID.PerspectiveColumn, ObjectID.PerspectiveHierarchy, ObjectID.PerspectiveMeasure, ObjectID.RoleMembership, and ObjectID.TablePermission for SQL Server 2017. Major 3.1.5.2.1.1.1.12 Create ObjectTranslations Added the ObjectID.Variation element. Major Create TablePermissions the MetadataPermission element for SQL Server 2017. Major Create Variations Added section. Major Create ExtendedProperties Added section. Major Create Expressions Added section for SQL Server 2017. Major Create ColumnPermissions section for SQL Server 2017. Major Create DetailRowsDefinition section for SQL Server 2017. Alter Model description of the DataAccessOptions element for SQL Server 2017. Major 3.1.5.2.1.2.1.1 Model Added the DefaultMeasureID, DefaultMeasureID.Table, and DefaultMeasureID.Measure elements.
translations Revised schema for variations and expressions properties. linguisticMetadata Revised section for extendedProperty objects. Major perspective Revised section for extendedProperty objects. Major perspectiveTable Revised section for extendedProperty objects. Major perspectiveColumn Revised section for extendedProperty objects. Major perspectiveHierarchy Revised section for extendedProperty objects. Major perspectiveMeasure Revised section for extendedProperty objects. Major role Revised section for extendedProperty objects. Major roleMembership Revised section for extendedProperty objects. Major tablePermission metadataPermission information for SQL Server 2017. Major 3.1.5.2.2.1.22 tablePermission Revised section for extendedProperty objects. Major variation Added section. Major extendedProperty Added section. Major expression Added section for SQL Server 2017. Major 3.1.5.2.2.1.25 expression Revised section for extendedProperty objects. Major columnPermission Added section for SQL Server 2017. Major 3.1.5.2.2.1.26 columnPermission Revised section for extendedProperty objects. detailRowsDefinition section for SQL Server 2017. Major Request Revised schema to add overrides. Major Request Added the security property. Major Server Response Replaced the FastCombine element with the DataAccessOptions element for SQL Server 2017. Minor Appendix A: Product Behavior Added SQL Server 2017 to the product applicability list. Major
A 17 17 C 17 270 18 E Examples 264 263 254 102 F 17 G 11 I 266 266 13 11 M Messages 18 N 18 12 O 16 13 13 P 266 17 17 267 Protocol examples 264 263 254 R References 13 12 16 S Security 266 266 266 Server 62 62 62 253 252 62 17 T 252 270 18 18 18 V 17 17