6 Appendix A: Product Behavior

  • Article

The information in this specification is applicable to the following Microsoft products or supplemental software. References to product versions include updates to those products.

  • Microsoft SQL Server 2016

  • Microsoft SQL Server 2017

  • Microsoft SQL Server 2019

  • Microsoft SQL Server 2022

Exceptions, if any, are noted in this section. If an update version, service pack or Knowledge Base (KB) number appears with a product name, the behavior changed in that update. The new behavior also applies to subsequent updates unless otherwise specified. If a product edition appears with the product version, behavior is different in that product edition.

Unless otherwise specified, any statement of optional behavior in this specification that is prescribed using the terms "SHOULD" or "SHOULD NOT" implies product behavior in accordance with the SHOULD or SHOULD NOT prescription. Unless otherwise specified, the term "MAY" implies that the product does not follow the prescription.

<1> Section 1.4:  The following table identifies Microsoft SQL Server Analysis Services Tabular mode compatibility levels of 1200 and higher and the products to which they are applicable. Newer releases of Analysis Services support Tabular mode compatibility levels at 1200 and higher. For example, Microsoft SQL Server 2022 Analysis Services supports Tabular mode compatibility levels 1200, 1400, 1500, and 1600.

SSAS Tabular mode compatibility level

Product introduced

1200

SQL Server 2016 Analysis Services

1400

SQL Server 2017 Analysis Services

1500

SQL Server 2019 Analysis Services

1600

SQL Server 2022 Analysis Services

<2> Section 2.2.3.1:  The ImpactType field is defined as optional. However, in SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services, the xsd:minOccurs="0" attribute for the ImpactType field is missing from the XSD in the rowset.

<3> Section 2.2.5.1: Microsoft implementations do not support the StorageLocation property.

<4> Section 2.2.5.1: Analysis Services requires this value to be a valid Windows culture name, such as "en-US" or "de-DE".

<5> Section 2.2.5.1: SQL Server 2016 Analysis Services does not support the DataAccessOptions property.

<6> Section 2.2.5.1: SQL Server 2016 Analysis Services does not support the DefaultMeasureID property.

<7> Section 2.2.5.1: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the ForceUniqueNames property.

<8> Section 2.2.5.1: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the DiscourageImplicitMeasures property.

<9> Section 2.2.5.1: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the DataSourceDefaultMaxConnections property.

<10> Section 2.2.5.1: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the SourceQueryCulture property.

<11> Section 2.2.5.1: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the MAttributes property.

<12> Section 2.2.5.1: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the DiscourageCompositeModels property.

<13> Section 2.2.5.1: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the AutomaticAggregationOptions property.

<14> Section 2.2.5.1: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the MaxParallelismPerRefresh property.

<15> Section 2.2.5.1: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the MaxParallelismPerQuery property.

<16> Section 2.2.5.2: SQL Server 2016 Analysis Services does not support the "Structured" enumeration value.

<17> Section 2.2.5.2: In Analysis Services, the behavior of the value "Default" is dependent upon the context in which impersonation is used.

<18> Section 2.2.5.2: In Analysis Services, the user account is the Windows user account.

<19> Section 2.2.5.2: Microsoft implementations do not support the Snapshot value.

<20> Section 2.2.5.2: SQL Server 2016 Analysis Services does not support the ConnectionDetails property.

<21> Section 2.2.5.2: SQL Server 2016 Analysis Services does not support the Options property.

<22> Section 2.2.5.2: SQL Server 2016 Analysis Services does not support the Credential property.

<23> Section 2.2.5.2: SQL Server 2016 Analysis Services does not support the ContextExpression property.

<24> Section 2.2.5.3: SQL Server 2016 Analysis Services does not support the ShowAsVariationsOnly property.

<25> Section 2.2.5.3: SQL Server 2016 Analysis Services does not support the IsPrivate property.

<26> Section 2.2.5.3: SQL Server 2016 Analysis Services does not support the DefaultDetailRowsDefinitionID property.

<27> Section 2.2.5.3: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the CalculationGroupID property.

<28> Section 2.2.5.3: Analysis Services does not support the RefreshPolicyID property.

<29> Section 2.2.5.3: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the ExcludeFromModelRefresh property.

<30> Section 2.2.5.3: Analysis Services does not support the AlternateSourcePrecedence property.

<31> Section 2.2.5.3: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the LineageTag property.

<32> Section 2.2.5.3: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the SourceLineageTag property.

<33> Section 2.2.5.3: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the SystemManaged property.

<34> Section 2.2.5.3: Analysis Services does not support the ExcludeFromAutomaticAggregations property.

<35> Section 2.2.5.4:  For more information on the use of DefaultDetails, see [MSDN-DEFDETAILS].

<36> Section 2.2.5.4: SQL Server 2016 Analysis Services does not support the EncodingHint property.

<37> Section 2.2.5.4: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the LineageTag property.

<38> Section 2.2.5.4: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the SourceLineageTag property.

<39> Section 2.2.5.6: SQL Server 2016 Analysis Services does not support the "M" value of the Type property.

<40> Section 2.2.5.6: SQL Server 2016 Analysis Services does not support the "Entity" value of the Type property.

<41> Section 2.2.5.6: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the "CalculationGroup" value of the Type property.

<42> Section 2.2.5.6: SQL Server 2016 Analysis Services does not support DirectQuery mode for models at compatibility level 1400.

<43> Section 2.2.5.6: SQL Server 2016 Analysis Services does not support the RetainDataTillForceCalculate property.

<44> Section 2.2.5.6: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the QueryGroupID property.

<45> Section 2.2.5.6: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the ExpressionSourceID property.

<46> Section 2.2.5.6: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the MAttributes property.

<47> Section 2.2.5.7: By default, the ToCardinality property can only be set to 'One'.

<48> Section 2.2.5.7:  SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the "None" value of the SecurityFilteringBehavior property.

<49> Section 2.2.5.8: SQL Server 2016 Analysis Services does not support the DetailRowsDefinitionID property.

<50> Section 2.2.5.8: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, SQL Server 2019 Analysis Services, and SQL Server 2022 Analysis Services do not support the FormatStringDefinitionID property for the Measure object.

<51> Section 2.2.5.8: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the DataCategory property.

<52> Section 2.2.5.8: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the LineageTag property.

<53> Section 2.2.5.8: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the SourceLineageTag property.

<54> Section 2.2.5.9: SQL Server 2016 Analysis Services does not support the HideMembers property.

<55> Section 2.2.5.9: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the LineageTag property.

<56> Section 2.2.5.9: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the SourceLineageTag property.

<57> Section 2.2.5.10: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the LineageTag property.

<58> Section 2.2.5.10: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the SourceLineageTag property.

<59> Section 2.2.5.11: SQL Server 2016 Analysis Services does not support the "TM_TYPEID_Variation" value of the ObjectType property.

<60> Section 2.2.5.11: SQL Server 2016 Analysis Services does not support the "TM_TYPEID_Expression" value of the ObjectType property.

<61> Section 2.2.5.11: SQL Server 2016 Analysis Services does not support the "TM_TYPEID_ColumnPermission" value of the ObjectType property.

<62> Section 2.2.5.11: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the "TM_TYPEID_CalculationGroup" value of the ObjectType property.

<63> Section 2.2.5.11: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the "TM_TYPEID_QueryGroup" value of the ObjectType property.

<64> Section 2.2.5.12: Analysis Services provides a list of known values; however, other values are possible. Because StatusGraphic is a string property, each client can define and use its own specific set of known values. Examples of possible values for the StatusGraphic property include:

  • Five Bars Colored

  • Road Signs

  • Three Circles Colored

  • Three Flags Colored

  • Three Stars Colored

  • Traffic Light

These are not fixed or standard values and can be replaced with any suitable alternatives, or a completely new value can be defined and used.

<65> Section 2.2.5.12: Because TrendGraphic is a string property, each client can define and use its own specific set of known values. Examples of possible values for the TrendGraphic property include:

  • Standard Arrow

  • Status Arrow - Ascending

  • Status Arrow - Descending

  • Smiley Face

These are not fixed or standard values and can be replaced with any suitable alternatives, or a completely new value can be defined and used.

<66> Section 2.2.5.14: SQL Server 2016 Analysis Services does not support the "TM_TYPEID_Variation" value.

<67> Section 2.2.5.14: SQL Server 2016 Analysis Services does not support the "TM_TYPEID_Expression" value.

<68> Section 2.2.5.14: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the Altered property.

<69> Section 2.2.5.15: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the ContentType property.

<70> Section 2.2.5.22: In Analysis Services, the only supported value is an empty string, which indicates that Windows authentication is used.

<71> Section 2.2.5.22: The MemberType property is always "Auto" for the Windows identity provider.

<72> Section 2.2.5.23: SQL Server 2016 Analysis Services does not support the MetadataPermission property.

<73> Section 2.2.5.24: SQL Server 2016 Analysis Services does not support the Variation object.

<74> Section 2.2.5.25: SQL Server 2016 Analysis Services does not support the ExtendedProperty object.

<75> Section 2.2.5.26: SQL Server 2016 Analysis Services does not support the Expression object.

<76> Section 2.2.5.26: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the QueryGroupID property.

<77> Section 2.2.5.26: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the ParameterValuesColumnID property.

<78> Section 2.2.5.26: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the MAttributes property.

<79> Section 2.2.5.26: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the LineageTag property.

<80> Section 2.2.5.26: SQL Server 2016 Analysis Services, SQL Server 2017 Analysis Services, and SQL Server 2019 Analysis Services do not support the SourceLineageTag property.

<81> Section 2.2.5.27: SQL Server 2016 Analysis Services does not support the ColumnPermission object.

<82> Section 2.2.5.28: SQL Server 2016 Analysis Services does not support the DetailRowsDefinition object.

<83> Section 2.2.5.29: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the CalculationGroup object.

<84> Section 2.2.5.30: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the CalculationItem object.

<85> Section 2.2.5.31: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the FormatStringDefinition object. SQL Server 2019 Analysis Services and SQL Server 2022 Analysis Services support the FormatStringDefinition object for only the CalculationItem object.

<86> Section 2.2.5.32: SQL Server 2016 Analysis Services and SQL Server 2017 Analysis Services do not support the QueryGroup object.

<87> Section 3.1.5.2.1.2.1.10: The ID property is required to alter an annotation.

<88> Section 3.1.5.2.2.10: When the attach command is specified, the command succeeds and the database is attached to the server. However, in SQL Server 2019 earlier than SQL Server 2019 Cumulative Update 3 (CU3), a message is returned that indicates the failure of the attach command.