6 Appendix A: Product Behavior

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

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 2017 Analysis Services supports Tabular mode compatibility levels 1200 and 1400.

SSAS Tabular mode compatibility level

Product introduced

1200

Microsoft SQL Server 2016 Analysis Services

1400

SQL Server 2017 Analysis Services

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

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

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

<5> Section 2.2.5.1: SQL Server 2016 does not support the DefaultMeasureID property.

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

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

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

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

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

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

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

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

<14> Section 2.2.5.3: SQL Server 2016 does not support the ShowAsVariationsOnly property.

<15> Section 2.2.5.3: SQL Server 2016 does not support the IsPrivate property.

<16> Section 2.2.5.3: SQL Server 2016 does not support the DefaultDetailRowsDefinitionID property.

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

<18> Section 2.2.5.4: SQL Server 2016 does not support the EncodingHint property.

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

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

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

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

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

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

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

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

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

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

<29> 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.

<30> 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.

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

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

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

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

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

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

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

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

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

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

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