6 Appendix B: Product Behavior

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

  • Microsoft Excel 2013

  • Microsoft Excel 2016

  • Microsoft SQL Server 2012

  • Microsoft SQL Server 2014

  • Microsoft SQL Server 2016

  • Microsoft SQL Server 2017

Exceptions, if any, are noted below. If a service pack or Quick Fix Engineering (QFE) number appears with the product version, behavior changed in that service pack or QFE. The new behavior also applies to subsequent service packs of the product 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.6: The following table describes versions of conceptual schema definition language with business intelligence annotations (CSDLBI) and when they were introduced. Newer releases of SQL Server support previous CSDLBI versions. For example, SQL Server 2017 supports all previous CSDLBI versions.

Schema version

Release introduced

CSDLBI 1.0

SQL Server 2012

CSDLBI 1.1

Microsoft SQL Server 2012 Service Pack 1 (SP1); Excel 2013

CSDLBI 2.0

SQL Server 2012 SP1 Cumulative Update 4 (CU4); Microsoft Excel 2013 Service Pack 1 (SP1)

CSDLBI 2.5

SQL Server 2016

<2> Section 2.1.1: Microsoft Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the PreferOrdinalStringEquality attribute.

<3> Section 2.1.6: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the CrossFilterDirection attribute.

<4> Section 2.1.11: Microsoft SQL Server Analysis Services does not support the Caption attribute.

<5> Section 2.1.13: Analysis Services in SQL Server 2012, SQL Server 2014, and SQL Server 2016 does not support the ContainsHiddenMembers element.

<6> Section 2.1.13.1: Analysis Services in SQL Server 2012, SQL Server 2014, and SQL Server 2016 does not support the THideMembers simple type.

<7> Section 2.1.19: Analysis Services in Microsoft SQL Server 2012, SQL Server 2014, and SQL Server 2016 does not support the ContainsDetailRows element.

Show: