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 updates to those products.
Microsoft Excel 2013
Microsoft Excel 2016
Microsoft SQL Server 2012
Microsoft SQL Server 2014
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.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 2022 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 SQL Server Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the PreferOrdinalStringEquality attribute.
<3> Section 2.1.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the MultiColumnFiltering element.
<4> Section 2.1.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the DiscourageCompositeModels element.
<5> Section 2.1.3: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the QueryBatching element.
<6> Section 2.1.3: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the Variables element.
<7> Section 2.1.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the InOperator element.
<8> Section 2.1.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TableConstructor element.
<9> Section 2.1.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the ExecutionMetrics element.
<10> Section 2.1.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the VirtualColumns element.
<11> Section 2.1.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the DataSourceVariables element.
<12> Section 2.1.3: Analysis Services in Microsoft SQL Server does not support the VisualCalculations element.
<13> Section 2.1.3: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the DAXFunctions element.
<14> Section 2.1.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the MParameters element.
<15> Section 2.1.3.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TMultiColumnFiltering simple type.
<16> Section 2.1.3.6: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TDiscourageCompositeModels simple type.
<17> Section 2.1.3.8: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TQueryBatching simple type.
<18> Section 2.1.3.9: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the TVariables simple type.
<19> Section 2.1.3.10: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TInOperator simple type.
<20> Section 2.1.3.11: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TTableConstructor simple type.
<21> Section 2.1.3.12: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TExecutionMetrics simple type.
<22> Section 2.1.3.13: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TVirtualColumns simple type.
<23> Section 2.1.3.14: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TDataSourceVariables simple type.
<24> Section 2.1.3.15: Analysis Services in SQL Server does not support the TVisualCalculations simple type.
<25> Section 2.1.4: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the TDAXFunctions complex type.
<26> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the StringMinMax element.
<27> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TreatAs element.
<28> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the Error element.
<29> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the SampleAxisWithLocalMinMax element.
<30> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the SampleCartesianPointsByCover element.
<31> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the OptimizedNotInOperator element.
<32> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the NonVisual element.
<33> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the IsAfter element.
<34> Section 2.1.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the FormatByLocale element.
<35> Section 2.1.4.4: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TStringMinMax simple type.
<36> Section 2.1.4.6: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TTreatAs simple type.
<37> Section 2.1.4.7: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TError simple type.
<38> Section 2.1.4.8: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TSampleAxisWithLocalMinMax simple type.
<39> Section 2.1.4.9: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TSampleCartesianPointsByCover simple type.
<40> Section 2.1.4.10: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TOptimizedNotInOperator simple type.
<41> Section 2.1.4.11: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TNonVisual simple type.
<42> Section 2.1.4.12: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TIsAfter simple type.
<43> Section 2.1.4.13: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TFormatByLocale simple type.
<44> Section 2.1.5: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TMParameters complex type.
<45> Section 2.1.6: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TMParameter complex type.
<46> Section 2.1.7: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TParameterValuesColumn complex type.
<47> Section 2.1.8: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the LineageTag attribute.
<48> Section 2.1.8: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the Private attribute for the TEntitySet complex type.
<49> Section 2.1.8: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the ShowAsVariationsOnly attribute.
<50> Section 2.1.9: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the CrossFilterDirection attribute.
<51> Section 2.1.9: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the Behavior attribute.
<52> Section 2.1.9.2: Analysis Services in SQL Server 2012 and SQL Server 2014 does not support the TCrossFilterDirection simple type.
<53> Section 2.1.9.3: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the TBehavior simple type.
<54> Section 2.1.10: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TCultures complex type.
<55> Section 2.1.11: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the TCulture complex type.
<56> Section 2.1.12: Analysis Services in SQL Server does not support the IsCalculationGroup attribute.
<57> Section 2.1.15: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the Cultures element.
<58> Section 2.1.15: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the LineageTag attribute.
<59> Section 2.1.18: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the Cultures element.
<60> Section 2.1.19: Analysis Services does not support the Caption attribute.
<61> Section 2.1.21: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the Cultures element.
<62> Section 2.1.21: Analysis Services in SQL Server 2012, SQL Server 2014, and SQL Server 2016 does not support the ContainsHiddenMembers element.
<63> Section 2.1.21: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the LineageTag attribute.
<64> Section 2.1.21.1: Analysis Services in SQL Server 2012, SQL Server 2014, and SQL Server 2016 does not support the THideMembers simple type.
<65> Section 2.1.22: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the Cultures element.
<66> Section 2.1.22: Analysis Services in SQL Server does not support the Private attribute.
<67> Section 2.1.22: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the LineageTag attribute.
<68> Section 2.1.22: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the IsError attribute.
<69> Section 2.1.27: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 does not support the Cultures element.
<70> Section 2.1.27: Analysis Services in SQL Server 2012, SQL Server 2014, and SQL Server 2016 does not support the ContainsDetailRows element.
<71> Section 2.1.27: Analysis Services in SQL Server does not support the DistributiveBy element.
<72> Section 2.1.27: Analysis Services in SQL Server does not support the Private attribute.
<73> Section 2.1.27: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 does not support the Contents attribute.
<74> Section 2.1.27: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 , and SQL Server 2019 does not support the LineageTag attribute.
<75> Section 2.1.27: Analysis Services in SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 , and SQL Server 2019 does not support the IsError attribute.
<76> Section 2.1.28: Analysis Services in SQL Server does not support the TDistributiveBy complex type.
<77> Section 2.1.28: Analysis Services in SQL Server does not support the AggregationKind attribute.
<78> Section 2.1.28.1: Analysis Services in SQL Server does not support the TAggregationKind simple type.