ࡱ > H # # o# p# q# r# s# t# u# v# w# x# y# z# {# |# }# ~# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # a d8 bjbj͚ t8 I\I\H J J ½ ½ ½ ½ ½ D l h Xi 5 Ҡ @ ` + R R R R R R R $ *l n *
S ½ ` `
S ½ ½ H i Z Z Z p ½ ½ R Z R Z Z a9 = k9 n . : , R (i 0 Xi
;
o
o X = =
o ½ > Z
S
S Z Xi
o J > : [MS-SSAS]: SQL Server Analysis Services Protocol Specification
Intellectual Property Rights Notice for Open Specifications Documentation
Technical Documentation. Microsoft publishes Open Specifications documentation for protocols, file formats, languages, standards as well as overviews of the interaction among each of these technologies.
Copyrights. This documentation is covered by Microsoft copyrights. Regardless of any other terms that are contained in the terms of use for the Microsoft website that hosts this documentation, you may make copies of it in order to develop implementations of the technologies described in the Open Specifications and may distribute portions of it in your implementations using these technologies or your documentation as necessary to properly document the implementation. You may also distribute in your implementation, with or without modification, any schema, IDLs, or code samples that are included in the documentation. This permission also applies to any documents that are referenced in the Open Specifications.
No Trade Secrets. Microsoft does not claim any trade secret rights in this documentation.
Patents. Microsoft has patents that may cover your implementations of the technologies described in the Open Specifications. Neither this notice nor Microsoft's delivery of the documentation grants any licenses under those or any other Microsoft patents. However, a given Open Specification may be covered by Microsoft's Open Specification Promise (available here: HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=114384"http://www.microsoft.com/interop/osp) or the Community Promise (available here: HYPERLINK "http://www.microsoft.com/interop/cp/default.mspx"http://www.microsoft.com/interop/cp/default.mspx). If you would prefer a written license, or if the technologies described in the Open Specifications are not covered by the Open Specifications Promise or Community Promise, as applicable, patent licenses are available by contacting HYPERLINK "mailto:iplg@microsoft.com"iplg@microsoft.com.
Trademarks. The names of companies and products contained in this documentation may be covered by trademarks or similar intellectual property rights. This notice does not grant any licenses under those rights.
Fictitious Names. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted in this documentation are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred.
Reservation of Rights. All other rights are reserved, and this notice does not grant any rights other than specifically described above, whether by implication, estoppel, or otherwise.
Tools. The Open Specifications do not require the use of Microsoft programming tools or programming environments in order for you to develop an implementation. If you have access to Microsoft programming tools and environments you are free to take advantage of them. Certain Open Specifications are intended for use in conjunction with publicly available standard specifications and network programming art, and assumes that the reader either is familiar with the aforementioned material or has immediate access to it.
Revision Summary
DateRevision HistoryRevision ClassComments08/07/20090.1MajorFirst release.11/06/20090.2MinorUpdated the technical content.03/05/20101.0MajorUpdated and revised the technical content.Contents
TOC \f \h \t "DSTOC1-1,1,DSTOC1-2,2,DSTOC1-3,3,DSTOC1-4,4,DSTOC1-5,5,DSTOC1-6,6,DSTOC1-7,7,DSTOC1-8,8,DSTOC1-9,9,DSTOC2-2,2,DSTOC2-3,3,DSTOC2-4,4,DSTOC2-5,5,DSTOC2-6,6,DSTOC2-7,7,DSTOC2-8,8,DSTOC2-9,9,DSTOC3-3,3,DSTOC3-4,4,DSTOC3-5,5,DSTOC3-6,6,DSTOC3-7,7,DST HYPERLINK \l "_Toc255526756" 1 Introduction PAGEREF _Toc255526756 \h 13
HYPERLINK \l "_Toc255526757" 1.1 Glossary PAGEREF _Toc255526757 \h 13
HYPERLINK \l "_Toc255526758" 1.2 References PAGEREF _Toc255526758 \h 15
HYPERLINK \l "_Toc255526759" 1.2.1 Normative References PAGEREF _Toc255526759 \h 15
HYPERLINK \l "_Toc255526760" 1.2.2 Informative References PAGEREF _Toc255526760 \h 16
HYPERLINK \l "_Toc255526761" 1.3 Protocol Overview (Synopsis) PAGEREF _Toc255526761 \h 17
HYPERLINK \l "_Toc255526762" 1.4 Relationship to Other Protocols PAGEREF _Toc255526762 \h 18
HYPERLINK \l "_Toc255526763" 1.5 Prerequisites/Preconditions PAGEREF _Toc255526763 \h 19
HYPERLINK \l "_Toc255526764" 1.6 Applicability Statement PAGEREF _Toc255526764 \h 19
HYPERLINK \l "_Toc255526765" 1.7 Versioning and Capability Negotiation PAGEREF _Toc255526765 \h 19
HYPERLINK \l "_Toc255526766" 1.7.1 Versioning PAGEREF _Toc255526766 \h 19
HYPERLINK \l "_Toc255526767" 1.7.2 Capability Negotiation PAGEREF _Toc255526767 \h 19
HYPERLINK \l "_Toc255526768" 1.8 Vendor-Extensible Fields PAGEREF _Toc255526768 \h 19
HYPERLINK \l "_Toc255526769" 1.9 Standards Assignments PAGEREF _Toc255526769 \h 20
HYPERLINK \l "_Toc255526770" 2 Messages PAGEREF _Toc255526770 \h 21
HYPERLINK \l "_Toc255526771" 2.1 Transport PAGEREF _Toc255526771 \h 21
HYPERLINK \l "_Toc255526772" 2.1.1 TCP PAGEREF _Toc255526772 \h 21
HYPERLINK \l "_Toc255526773" 2.1.2 HTTP/HTTPS PAGEREF _Toc255526773 \h 23
HYPERLINK \l "_Toc255526774" 2.1.3 Encryption PAGEREF _Toc255526774 \h 23
HYPERLINK \l "_Toc255526775" 2.1.4 Compression PAGEREF _Toc255526775 \h 23
HYPERLINK \l "_Toc255526776" 2.1.5 Binary XML PAGEREF _Toc255526776 \h 24
HYPERLINK \l "_Toc255526777" 2.2 Common Message Syntax PAGEREF _Toc255526777 \h 25
HYPERLINK \l "_Toc255526778" 2.2.1 Namespaces PAGEREF _Toc255526778 \h 25
HYPERLINK \l "_Toc255526779" 2.2.2 Messages PAGEREF _Toc255526779 \h 26
HYPERLINK \l "_Toc255526780" 2.2.3 Elements PAGEREF _Toc255526780 \h 26
HYPERLINK \l "_Toc255526781" 2.2.4 Complex Types PAGEREF _Toc255526781 \h 26
HYPERLINK \l "_Toc255526782" 2.2.4.1 Return Value Complex Types PAGEREF _Toc255526782 \h 26
HYPERLINK \l "_Toc255526783" 2.2.4.1.1 xmla-ds:mddataset Complex Type PAGEREF _Toc255526783 \h 26
HYPERLINK \l "_Toc255526784" 2.2.4.1.1.1 xmla-ds:OlapInfo Complex Type PAGEREF _Toc255526784 \h 27
HYPERLINK \l "_Toc255526785" 2.2.4.1.1.1.1 xmla-ds:CubeInfo PAGEREF _Toc255526785 \h 28
HYPERLINK \l "_Toc255526786" 2.2.4.1.1.1.1.1 OlapInfoCube PAGEREF _Toc255526786 \h 28
HYPERLINK \l "_Toc255526787" 2.2.4.1.1.1.2 xmla-ds:AxesInfo PAGEREF _Toc255526787 \h 28
HYPERLINK \l "_Toc255526788" 2.2.4.1.1.1.2.1 xmla-ds:AxisInfo PAGEREF _Toc255526788 \h 29
HYPERLINK \l "_Toc255526789" 2.2.4.1.1.1.2.1.1 xmla-ds:HierarchyInfo PAGEREF _Toc255526789 \h 29
HYPERLINK \l "_Toc255526790" 2.2.4.1.1.1.3 xmla-ds:CellInfo Complex Type PAGEREF _Toc255526790 \h 30
HYPERLINK \l "_Toc255526791" 2.2.4.1.1.2 xmla-ds:Axes Complex Type PAGEREF _Toc255526791 \h 30
HYPERLINK \l "_Toc255526792" 2.2.4.1.1.2.1 Axis PAGEREF _Toc255526792 \h 30
HYPERLINK \l "_Toc255526793" 2.2.4.1.1.2.1.1 SetType Model Group PAGEREF _Toc255526793 \h 31
HYPERLINK \l "_Toc255526794" 2.2.4.1.1.2.1.1.1 MembersType Complex Type PAGEREF _Toc255526794 \h 31
HYPERLINK \l "_Toc255526795" 2.2.4.1.1.2.1.1.2 MemberType Complex Type PAGEREF _Toc255526795 \h 32
HYPERLINK \l "_Toc255526796" 2.2.4.1.1.2.1.1.3 TuplesType Complex Type PAGEREF _Toc255526796 \h 32
HYPERLINK \l "_Toc255526797" 2.2.4.1.1.2.1.1.4 TupleType Complex Type PAGEREF _Toc255526797 \h 32
HYPERLINK \l "_Toc255526798" 2.2.4.1.1.2.1.1.5 SetListType Complex Type PAGEREF _Toc255526798 \h 33
HYPERLINK \l "_Toc255526799" 2.2.4.1.1.2.1.1.5.1 msxmla:NormTupleSet Complex Type PAGEREF _Toc255526799 \h 33
HYPERLINK \l "_Toc255526800" 2.2.4.1.1.3 xmla-ds:CellData Complex Type PAGEREF _Toc255526800 \h 34
HYPERLINK \l "_Toc255526801" 2.2.4.1.1.3.1 CellOrdinal Attribute PAGEREF _Toc255526801 \h 34
HYPERLINK \l "_Toc255526802" 2.2.4.1.1.3.2 Cell Value Errors PAGEREF _Toc255526802 \h 35
HYPERLINK \l "_Toc255526803" 2.2.4.1.2 xmla-e:emptyresult Complex Type PAGEREF _Toc255526803 \h 36
HYPERLINK \l "_Toc255526804" 2.2.4.1.3 xmla-rs:rowset Complex Type PAGEREF _Toc255526804 \h 36
HYPERLINK \l "_Toc255526805" 2.2.4.1.3.1 xmla-rs:row Complex Type PAGEREF _Toc255526805 \h 37
HYPERLINK \l "_Toc255526806" 2.2.4.1.3.1.1 Nested Rowsets PAGEREF _Toc255526806 \h 37
HYPERLINK \l "_Toc255526807" 2.2.4.1.4 xmla-m:results Complex Type PAGEREF _Toc255526807 \h 38
HYPERLINK \l "_Toc255526808" 2.2.4.1.5 Error and Warning Complex Types PAGEREF _Toc255526808 \h 38
HYPERLINK \l "_Toc255526809" 2.2.4.1.5.1 xmla-x:Exception PAGEREF _Toc255526809 \h 38
HYPERLINK \l "_Toc255526810" 2.2.4.1.5.2 xmla-x:Messages PAGEREF _Toc255526810 \h 38
HYPERLINK \l "_Toc255526811" 2.2.4.1.5.2.1 WarningType PAGEREF _Toc255526811 \h 39
HYPERLINK \l "_Toc255526812" 2.2.4.1.5.2.1.1 MessageLocation PAGEREF _Toc255526812 \h 39
HYPERLINK \l "_Toc255526813" 2.2.4.2 Object Definition Complex Types PAGEREF _Toc255526813 \h 41
HYPERLINK \l "_Toc255526814" 2.2.4.2.1 Rules that Apply to All Complex Types PAGEREF _Toc255526814 \h 41
HYPERLINK \l "_Toc255526815" 2.2.4.2.1.1 Names, IDs, and References PAGEREF _Toc255526815 \h 41
HYPERLINK \l "_Toc255526816" 2.2.4.2.1.2 String Elements PAGEREF _Toc255526816 \h 42
HYPERLINK \l "_Toc255526817" 2.2.4.2.1.3 Versioning PAGEREF _Toc255526817 \h 42
HYPERLINK \l "_Toc255526818" 2.2.4.2.2 Complex Type Definitions for Server Object Hierarchy PAGEREF _Toc255526818 \h 43
HYPERLINK \l "_Toc255526819" 2.2.4.2.2.1 MajorObject PAGEREF _Toc255526819 \h 43
HYPERLINK \l "_Toc255526820" 2.2.4.2.2.2 Server PAGEREF _Toc255526820 \h 44
HYPERLINK \l "_Toc255526821" 2.2.4.2.2.2.1 ServerProperty PAGEREF _Toc255526821 \h 46
HYPERLINK \l "_Toc255526822" 2.2.4.2.2.3 Assembly PAGEREF _Toc255526822 \h 47
HYPERLINK \l "_Toc255526823" 2.2.4.2.2.3.1 ComAssembly PAGEREF _Toc255526823 \h 47
HYPERLINK \l "_Toc255526824" 2.2.4.2.2.3.2 ClrAssembly PAGEREF _Toc255526824 \h 48
HYPERLINK \l "_Toc255526825" 2.2.4.2.2.3.2.1 ClrAssemblyFile PAGEREF _Toc255526825 \h 49
HYPERLINK \l "_Toc255526826" 2.2.4.2.2.3.2.2 DataBlock PAGEREF _Toc255526826 \h 50
HYPERLINK \l "_Toc255526827" 2.2.4.2.2.4 Trace PAGEREF _Toc255526827 \h 50
HYPERLINK \l "_Toc255526828" 2.2.4.2.2.4.1 Event PAGEREF _Toc255526828 \h 51
HYPERLINK \l "_Toc255526829" 2.2.4.2.2.4.1.1 EventColumn PAGEREF _Toc255526829 \h 52
HYPERLINK \l "_Toc255526830" 2.2.4.2.2.4.2 TraceFilter PAGEREF _Toc255526830 \h 52
HYPERLINK \l "_Toc255526831" 2.2.4.2.2.5 Database PAGEREF _Toc255526831 \h 53
HYPERLINK \l "_Toc255526832" 2.2.4.2.2.5.1 Account PAGEREF _Toc255526832 \h 59
HYPERLINK \l "_Toc255526833" 2.2.4.2.2.6 DataSource PAGEREF _Toc255526833 \h 60
HYPERLINK \l "_Toc255526834" 2.2.4.2.2.6.1 RelationalDataSource PAGEREF _Toc255526834 \h 62
HYPERLINK \l "_Toc255526835" 2.2.4.2.2.6.2 OlapDataSource PAGEREF _Toc255526835 \h 63
HYPERLINK \l "_Toc255526836" 2.2.4.2.2.6.3 PushedDataSource PAGEREF _Toc255526836 \h 63
HYPERLINK \l "_Toc255526837" 2.2.4.2.2.7 DataSourceView PAGEREF _Toc255526837 \h 64
HYPERLINK \l "_Toc255526838" 2.2.4.2.2.8 Dimension PAGEREF _Toc255526838 \h 65
HYPERLINK \l "_Toc255526839" 2.2.4.2.2.8.1 DimensionAttribute PAGEREF _Toc255526839 \h 71
HYPERLINK \l "_Toc255526840" 2.2.4.2.2.8.1.1 AttributeRelationship PAGEREF _Toc255526840 \h 84
HYPERLINK \l "_Toc255526841" 2.2.4.2.2.8.2 Hierarchy PAGEREF _Toc255526841 \h 85
HYPERLINK \l "_Toc255526842" 2.2.4.2.2.8.2.1 Level PAGEREF _Toc255526842 \h 87
HYPERLINK \l "_Toc255526843" 2.2.4.2.2.9 Cube PAGEREF _Toc255526843 \h 88
HYPERLINK \l "_Toc255526844" 2.2.4.2.2.9.1 CubeDimension PAGEREF _Toc255526844 \h 93
HYPERLINK \l "_Toc255526845" 2.2.4.2.2.9.2 CubeAttribute PAGEREF _Toc255526845 \h 95
HYPERLINK \l "_Toc255526846" 2.2.4.2.2.9.3 CubeHierarchy PAGEREF _Toc255526846 \h 96
HYPERLINK \l "_Toc255526847" 2.2.4.2.2.9.4 Kpi PAGEREF _Toc255526847 \h 97
HYPERLINK \l "_Toc255526848" 2.2.4.2.2.9.5 Action PAGEREF _Toc255526848 \h 99
HYPERLINK \l "_Toc255526849" 2.2.4.2.2.9.5.1 StandardAction PAGEREF _Toc255526849 \h 100
HYPERLINK \l "_Toc255526850" 2.2.4.2.2.9.5.2 ReportAction PAGEREF _Toc255526850 \h 101
HYPERLINK \l "_Toc255526851" 2.2.4.2.2.9.5.2.1 ReportParameter PAGEREF _Toc255526851 \h 103
HYPERLINK \l "_Toc255526852" 2.2.4.2.2.9.5.2.2 ReportFormatParameter PAGEREF _Toc255526852 \h 104
HYPERLINK \l "_Toc255526853" 2.2.4.2.2.9.5.3 DrillThroughAction PAGEREF _Toc255526853 \h 104
HYPERLINK \l "_Toc255526854" 2.2.4.2.2.10 MdxScript PAGEREF _Toc255526854 \h 106
HYPERLINK \l "_Toc255526855" 2.2.4.2.2.10.1 CalculationProperty PAGEREF _Toc255526855 \h 107
HYPERLINK \l "_Toc255526856" 2.2.4.2.2.10.2 Command PAGEREF _Toc255526856 \h 109
HYPERLINK \l "_Toc255526857" 2.2.4.2.2.11 MeasureGroup PAGEREF _Toc255526857 \h 109
HYPERLINK \l "_Toc255526858" 2.2.4.2.2.11.1 MeasureGroupDimension PAGEREF _Toc255526858 \h 113
HYPERLINK \l "_Toc255526859" 2.2.4.2.2.11.1.1 ManyToManyMeasureGroupDimension PAGEREF _Toc255526859 \h 114
HYPERLINK \l "_Toc255526860" 2.2.4.2.2.11.1.2 RegularMeasureGroupDimension PAGEREF _Toc255526860 \h 114
HYPERLINK \l "_Toc255526861" 2.2.4.2.2.11.1.3 ReferenceMeasureGroupDimension PAGEREF _Toc255526861 \h 115
HYPERLINK \l "_Toc255526862" 2.2.4.2.2.11.1.4 DegenerateMeasureGroupDimension PAGEREF _Toc255526862 \h 117
HYPERLINK \l "_Toc255526863" 2.2.4.2.2.11.1.5 DataMiningMeasureGroupDimension PAGEREF _Toc255526863 \h 118
HYPERLINK \l "_Toc255526864" 2.2.4.2.2.11.2 MeasureGroupAttribute PAGEREF _Toc255526864 \h 119
HYPERLINK \l "_Toc255526865" 2.2.4.2.2.11.3 Measure PAGEREF _Toc255526865 \h 120
HYPERLINK \l "_Toc255526866" 2.2.4.2.2.12 AggregationDesign PAGEREF _Toc255526866 \h 122
HYPERLINK \l "_Toc255526867" 2.2.4.2.2.12.1 AggregationDesignDimension PAGEREF _Toc255526867 \h 123
HYPERLINK \l "_Toc255526868" 2.2.4.2.2.12.1.1 AggregationDesignAttribute PAGEREF _Toc255526868 \h 124
HYPERLINK \l "_Toc255526869" 2.2.4.2.2.12.2 Aggregation PAGEREF _Toc255526869 \h 124
HYPERLINK \l "_Toc255526870" 2.2.4.2.2.12.2.1 AggregationDimension PAGEREF _Toc255526870 \h 125
HYPERLINK \l "_Toc255526871" 2.2.4.2.2.12.2.1.1 AggregationAttribute PAGEREF _Toc255526871 \h 126
HYPERLINK \l "_Toc255526872" 2.2.4.2.2.13 Partition PAGEREF _Toc255526872 \h 126
HYPERLINK \l "_Toc255526873" 2.2.4.2.2.13.1 AggregationInstance PAGEREF _Toc255526873 \h 130
HYPERLINK \l "_Toc255526874" 2.2.4.2.2.13.1.1 AggregationInstanceDimension PAGEREF _Toc255526874 \h 131
HYPERLINK \l "_Toc255526875" 2.2.4.2.2.13.1.2 AggregationInstanceAttribute PAGEREF _Toc255526875 \h 132
HYPERLINK \l "_Toc255526876" 2.2.4.2.2.13.1.3 AggregationInstanceMeasure PAGEREF _Toc255526876 \h 132
HYPERLINK \l "_Toc255526877" 2.2.4.2.2.14 Perspective PAGEREF _Toc255526877 \h 133
HYPERLINK \l "_Toc255526878" 2.2.4.2.2.14.1 PerspectiveDimension PAGEREF _Toc255526878 \h 134
HYPERLINK \l "_Toc255526879" 2.2.4.2.2.14.1.1 PerspectiveAttribute PAGEREF _Toc255526879 \h 135
HYPERLINK \l "_Toc255526880" 2.2.4.2.2.14.1.2 PerspectiveHierarchy PAGEREF _Toc255526880 \h 136
HYPERLINK \l "_Toc255526881" 2.2.4.2.2.14.2 PerspectiveMeasureGroup PAGEREF _Toc255526881 \h 136
HYPERLINK \l "_Toc255526882" 2.2.4.2.2.14.2.1 PerspectiveMeasure PAGEREF _Toc255526882 \h 137
HYPERLINK \l "_Toc255526883" 2.2.4.2.2.14.3 PerspectiveCalculation PAGEREF _Toc255526883 \h 137
HYPERLINK \l "_Toc255526884" 2.2.4.2.2.14.4 PerspectiveKpi PAGEREF _Toc255526884 \h 138
HYPERLINK \l "_Toc255526885" 2.2.4.2.2.14.5 PerspectiveAction PAGEREF _Toc255526885 \h 139
HYPERLINK \l "_Toc255526886" 2.2.4.2.2.15 MiningStructure PAGEREF _Toc255526886 \h 139
HYPERLINK \l "_Toc255526887" 2.2.4.2.2.15.1 MiningStructureColumn PAGEREF _Toc255526887 \h 142
HYPERLINK \l "_Toc255526888" 2.2.4.2.2.15.1.1 ScalarMiningStructureColumn PAGEREF _Toc255526888 \h 142
HYPERLINK \l "_Toc255526889" 2.2.4.2.2.15.1.2 TableMiningstructureColumn PAGEREF _Toc255526889 \h 145
HYPERLINK \l "_Toc255526890" 2.2.4.2.2.16 MiningModel PAGEREF _Toc255526890 \h 146
HYPERLINK \l "_Toc255526891" 2.2.4.2.2.16.1 MiningModelingFlag PAGEREF _Toc255526891 \h 148
HYPERLINK \l "_Toc255526892" 2.2.4.2.2.16.2 MiningModelColumn PAGEREF _Toc255526892 \h 149
HYPERLINK \l "_Toc255526893" 2.2.4.2.2.16.3 AlgorithmParameter PAGEREF _Toc255526893 \h 150
HYPERLINK \l "_Toc255526894" 2.2.4.2.2.16.4 FoldingParameters PAGEREF _Toc255526894 \h 151
HYPERLINK \l "_Toc255526895" 2.2.4.2.2.17 Annotation PAGEREF _Toc255526895 \h 151
HYPERLINK \l "_Toc255526896" 2.2.4.2.2.18 Translation PAGEREF _Toc255526896 \h 152
HYPERLINK \l "_Toc255526897" 2.2.4.2.2.18.1 AttributeTranslation PAGEREF _Toc255526897 \h 153
HYPERLINK \l "_Toc255526898" 2.2.4.2.2.19 DataItem PAGEREF _Toc255526898 \h 153
HYPERLINK \l "_Toc255526899" 2.2.4.2.2.20 Binding PAGEREF _Toc255526899 \h 155
HYPERLINK \l "_Toc255526900" 2.2.4.2.2.20.1 ColumnBinding PAGEREF _Toc255526900 \h 156
HYPERLINK \l "_Toc255526901" 2.2.4.2.2.20.2 RowBinding PAGEREF _Toc255526901 \h 156
HYPERLINK \l "_Toc255526902" 2.2.4.2.2.20.3 DataSourceViewBinding PAGEREF _Toc255526902 \h 156
HYPERLINK \l "_Toc255526903" 2.2.4.2.2.20.4 MeasureBinding PAGEREF _Toc255526903 \h 157
HYPERLINK \l "_Toc255526904" 2.2.4.2.2.20.5 AttributeBinding PAGEREF _Toc255526904 \h 157
HYPERLINK \l "_Toc255526905" 2.2.4.2.2.20.6 UserDefinedGroupBinding PAGEREF _Toc255526905 \h 158
HYPERLINK \l "_Toc255526906" 2.2.4.2.2.20.6.1 Group PAGEREF _Toc255526906 \h 159
HYPERLINK \l "_Toc255526907" 2.2.4.2.2.20.7 CubeAttributeBinding PAGEREF _Toc255526907 \h 159
HYPERLINK \l "_Toc255526908" 2.2.4.2.2.20.8 DimensionBinding PAGEREF _Toc255526908 \h 160
HYPERLINK \l "_Toc255526909" 2.2.4.2.2.20.9 CubeDimensionBinding PAGEREF _Toc255526909 \h 161
HYPERLINK \l "_Toc255526910" 2.2.4.2.2.20.10 MeasureGroupBinding PAGEREF _Toc255526910 \h 162
HYPERLINK \l "_Toc255526911" 2.2.4.2.2.20.11 MeasureGroupDimensionBinding PAGEREF _Toc255526911 \h 163
HYPERLINK \l "_Toc255526912" 2.2.4.2.2.20.12 TimeBinding PAGEREF _Toc255526912 \h 164
HYPERLINK \l "_Toc255526913" 2.2.4.2.2.20.13 TimeAttributeBinding PAGEREF _Toc255526913 \h 166
HYPERLINK \l "_Toc255526914" 2.2.4.2.2.20.14 InheritedBinding PAGEREF _Toc255526914 \h 167
HYPERLINK \l "_Toc255526915" 2.2.4.2.2.20.15 TabularBinding PAGEREF _Toc255526915 \h 167
HYPERLINK \l "_Toc255526916" 2.2.4.2.2.20.16 TableBinding PAGEREF _Toc255526916 \h 167
HYPERLINK \l "_Toc255526917" 2.2.4.2.2.20.17 QueryBinding PAGEREF _Toc255526917 \h 168
HYPERLINK \l "_Toc255526918" 2.2.4.2.2.20.18 DSVTableBinding PAGEREF _Toc255526918 \h 168
HYPERLINK \l "_Toc255526919" 2.2.4.2.2.20.19 ProactiveCachingBinding PAGEREF _Toc255526919 \h 168
HYPERLINK \l "_Toc255526920" 2.2.4.2.2.20.20 ProactiveCachingObjectNotificationBinding PAGEREF _Toc255526920 \h 169
HYPERLINK \l "_Toc255526921" 2.2.4.2.2.20.21 ProactiveCachingInheritedBinding PAGEREF _Toc255526921 \h 169
HYPERLINK \l "_Toc255526922" 2.2.4.2.2.20.22 ProactiveCachingTablesBinding PAGEREF _Toc255526922 \h 169
HYPERLINK \l "_Toc255526923" 2.2.4.2.2.20.22.1 TableNotification PAGEREF _Toc255526923 \h 170
HYPERLINK \l "_Toc255526924" 2.2.4.2.2.20.23 ProactiveCachingQueryBinding PAGEREF _Toc255526924 \h 170
HYPERLINK \l "_Toc255526925" 2.2.4.2.2.20.23.1 QueryNotification PAGEREF _Toc255526925 \h 171
HYPERLINK \l "_Toc255526926" 2.2.4.2.2.20.24 ProactiveCachingIncrementalProcessingBinding PAGEREF _Toc255526926 \h 171
HYPERLINK \l "_Toc255526927" 2.2.4.2.2.20.24.1 IncrementalProcessingNotification PAGEREF _Toc255526927 \h 172
HYPERLINK \l "_Toc255526928" 2.2.4.2.2.20.25 eng200_200:RowNumberBinding PAGEREF _Toc255526928 \h 172
HYPERLINK \l "_Toc255526929" 2.2.4.2.2.20.26 CalculatedMeasureBinding PAGEREF _Toc255526929 \h 173
HYPERLINK \l "_Toc255526930" 2.2.4.2.2.20.27 eng200_200:ExpressionBinding PAGEREF _Toc255526930 \h 173
HYPERLINK \l "_Toc255526931" 2.2.4.2.2.21 Permission PAGEREF _Toc255526931 \h 173
HYPERLINK \l "_Toc255526932" 2.2.4.2.2.21.1 CubeDimensionPermission PAGEREF _Toc255526932 \h 175
HYPERLINK \l "_Toc255526933" 2.2.4.2.2.21.2 AttributePermission PAGEREF _Toc255526933 \h 176
HYPERLINK \l "_Toc255526934" 2.2.4.2.2.21.3 CellPermission PAGEREF _Toc255526934 \h 177
HYPERLINK \l "_Toc255526935" 2.2.4.2.2.22 DatabasePermission PAGEREF _Toc255526935 \h 178
HYPERLINK \l "_Toc255526936" 2.2.4.2.2.23 DataSourcePermission PAGEREF _Toc255526936 \h 179
HYPERLINK \l "_Toc255526937" 2.2.4.2.2.24 DimensionPermission PAGEREF _Toc255526937 \h 180
HYPERLINK \l "_Toc255526938" 2.2.4.2.2.25 MiningStructurePermission PAGEREF _Toc255526938 \h 181
HYPERLINK \l "_Toc255526939" 2.2.4.2.2.26 MiningModelPermission PAGEREF _Toc255526939 \h 183
HYPERLINK \l "_Toc255526940" 2.2.4.2.2.27 CubePermission PAGEREF _Toc255526940 \h 184
HYPERLINK \l "_Toc255526941" 2.2.4.2.2.28 Role PAGEREF _Toc255526941 \h 185
HYPERLINK \l "_Toc255526942" 2.2.4.2.2.28.1 Member PAGEREF _Toc255526942 \h 186
HYPERLINK \l "_Toc255526943" 2.2.4.2.2.29 ProactiveCaching PAGEREF _Toc255526943 \h 187
HYPERLINK \l "_Toc255526944" 2.2.4.2.2.30 ErrorConfiguration PAGEREF _Toc255526944 \h 188
HYPERLINK \l "_Toc255526945" 2.2.4.2.2.31 ImpersonationInfo PAGEREF _Toc255526945 \h 190
HYPERLINK \l "_Toc255526946" 2.2.4.3 TraceDefinition Complex Types PAGEREF _Toc255526946 \h 191
HYPERLINK \l "_Toc255526947" 2.2.4.3.1 Trace_Definition_ProviderInfo PAGEREF _Toc255526947 \h 191
HYPERLINK \l "_Toc255526948" 2.2.4.3.2 Trace_Event_Categories PAGEREF _Toc255526948 \h 192
HYPERLINK \l "_Toc255526949" 2.2.4.3.2.1 TraceEvent PAGEREF _Toc255526949 \h 193
HYPERLINK \l "_Toc255526950" 2.2.4.3.2.1.1 EventColumn PAGEREF _Toc255526950 \h 194
HYPERLINK \l "_Toc255526951" 2.2.4.3.3 Trace_Columns PAGEREF _Toc255526951 \h 194
HYPERLINK \l "_Toc255526952" 2.2.5 Simple Types PAGEREF _Toc255526952 \h 195
HYPERLINK \l "_Toc255526953" 2.2.6 Attributes PAGEREF _Toc255526953 \h 195
HYPERLINK \l "_Toc255526954" 2.2.7 Groups PAGEREF _Toc255526954 \h 195
HYPERLINK \l "_Toc255526955" 2.2.8 Attribute Groups PAGEREF _Toc255526955 \h 195
HYPERLINK \l "_Toc255526956" 3 Protocol Details PAGEREF _Toc255526956 \h 196
HYPERLINK \l "_Toc255526957" 3.1 Server Details PAGEREF _Toc255526957 \h 196
HYPERLINK \l "_Toc255526958" 3.1.1 Abstract Data Model PAGEREF _Toc255526958 \h 196
HYPERLINK \l "_Toc255526959" 3.1.2 Timers PAGEREF _Toc255526959 \h 196
HYPERLINK \l "_Toc255526960" 3.1.3 Initialization PAGEREF _Toc255526960 \h 196
HYPERLINK \l "_Toc255526961" 3.1.4 Message Processing Events and Sequencing Rules PAGEREF _Toc255526961 \h 198
HYPERLINK \l "_Toc255526962" 3.1.4.1 Authenticate PAGEREF _Toc255526962 \h 198
HYPERLINK \l "_Toc255526963" 3.1.4.1.1 Messages PAGEREF _Toc255526963 \h 198
HYPERLINK \l "_Toc255526964" 3.1.4.1.1.1 AuthenticateSoapIn PAGEREF _Toc255526964 \h 199
HYPERLINK \l "_Toc255526965" 3.1.4.1.1.2 AuthenticateSoapOut PAGEREF _Toc255526965 \h 199
HYPERLINK \l "_Toc255526966" 3.1.4.1.2 Elements PAGEREF _Toc255526966 \h 199
HYPERLINK \l "_Toc255526967" 3.1.4.1.2.1 Authenticate PAGEREF _Toc255526967 \h 199
HYPERLINK \l "_Toc255526968" 3.1.4.1.2.2 AuthenticateResponse PAGEREF _Toc255526968 \h 200
HYPERLINK \l "_Toc255526969" 3.1.4.2 Discover PAGEREF _Toc255526969 \h 200
HYPERLINK \l "_Toc255526970" 3.1.4.2.1 Messages PAGEREF _Toc255526970 \h 201
HYPERLINK \l "_Toc255526971" 3.1.4.2.1.1 DiscoverSoapIn PAGEREF _Toc255526971 \h 201
HYPERLINK \l "_Toc255526972" 3.1.4.2.1.2 DiscoverSoapOut PAGEREF _Toc255526972 \h 201
HYPERLINK \l "_Toc255526973" 3.1.4.2.2 Elements PAGEREF _Toc255526973 \h 201
HYPERLINK \l "_Toc255526974" 3.1.4.2.2.1 Discover PAGEREF _Toc255526974 \h 201
HYPERLINK \l "_Toc255526975" 3.1.4.2.2.1.1 Restrictions and RestrictionList PAGEREF _Toc255526975 \h 203
HYPERLINK \l "_Toc255526976" 3.1.4.2.2.1.2 Properties Type PAGEREF _Toc255526976 \h 203
HYPERLINK \l "_Toc255526977" 3.1.4.2.2.1.2.1 PropertyList PAGEREF _Toc255526977 \h 204
HYPERLINK \l "_Toc255526978" 3.1.4.2.2.1.3 Discover Request Types PAGEREF _Toc255526978 \h 248
HYPERLINK \l "_Toc255526979" 3.1.4.2.2.1.3.1 DBSCHEMA_CATALOGS PAGEREF _Toc255526979 \h 248
HYPERLINK \l "_Toc255526980" 3.1.4.2.2.1.3.1.1 Columns PAGEREF _Toc255526980 \h 248
HYPERLINK \l "_Toc255526981" 3.1.4.2.2.1.3.2 DBSCHEMA_TABLES PAGEREF _Toc255526981 \h 249
HYPERLINK \l "_Toc255526982" 3.1.4.2.2.1.3.2.1 Columns PAGEREF _Toc255526982 \h 249
HYPERLINK \l "_Toc255526983" 3.1.4.2.2.1.3.3 DBSCHEMA_COLUMNS PAGEREF _Toc255526983 \h 251
HYPERLINK \l "_Toc255526984" 3.1.4.2.2.1.3.3.1 Columns PAGEREF _Toc255526984 \h 251
HYPERLINK \l "_Toc255526985" 3.1.4.2.2.1.3.4 DBSCHEMA_PROVIDER_TYPES PAGEREF _Toc255526985 \h 255
HYPERLINK \l "_Toc255526986" 3.1.4.2.2.1.3.4.1 Columns PAGEREF _Toc255526986 \h 255
HYPERLINK \l "_Toc255526987" 3.1.4.2.2.1.3.5 MDSCHEMA_CUBES RequestType PAGEREF _Toc255526987 \h 261
HYPERLINK \l "_Toc255526988" 3.1.4.2.2.1.3.5.1 Columns PAGEREF _Toc255526988 \h 261
HYPERLINK \l "_Toc255526989" 3.1.4.2.2.1.3.6 MDSCHEMA_DIMENSIONS PAGEREF _Toc255526989 \h 263
HYPERLINK \l "_Toc255526990" 3.1.4.2.2.1.3.6.1 Columns PAGEREF _Toc255526990 \h 263
HYPERLINK \l "_Toc255526991" 3.1.4.2.2.1.3.6.2 Additional Restrictions PAGEREF _Toc255526991 \h 266
HYPERLINK \l "_Toc255526992" 3.1.4.2.2.1.3.7 MDSCHEMA_HIERARCHIES PAGEREF _Toc255526992 \h 266
HYPERLINK \l "_Toc255526993" 3.1.4.2.2.1.3.7.1 Columns PAGEREF _Toc255526993 \h 266
HYPERLINK \l "_Toc255526994" 3.1.4.2.2.1.3.7.2 Additional Restrictions PAGEREF _Toc255526994 \h 271
HYPERLINK \l "_Toc255526995" 3.1.4.2.2.1.3.8 MDSCHEMA_LEVELS PAGEREF _Toc255526995 \h 271
HYPERLINK \l "_Toc255526996" 3.1.4.2.2.1.3.8.1 Columns PAGEREF _Toc255526996 \h 272
HYPERLINK \l "_Toc255526997" 3.1.4.2.2.1.3.8.2 Additional Restrictions PAGEREF _Toc255526997 \h 279
HYPERLINK \l "_Toc255526998" 3.1.4.2.2.1.3.9 MDSCHEMA_MEASURES PAGEREF _Toc255526998 \h 280
HYPERLINK \l "_Toc255526999" 3.1.4.2.2.1.3.9.1 Columns PAGEREF _Toc255526999 \h 280
HYPERLINK \l "_Toc255527000" 3.1.4.2.2.1.3.9.2 Additional Restrictions PAGEREF _Toc255527000 \h 283
HYPERLINK \l "_Toc255527001" 3.1.4.2.2.1.3.10 MDSCHEMA_PROPERTIES PAGEREF _Toc255527001 \h 284
HYPERLINK \l "_Toc255527002" 3.1.4.2.2.1.3.10.1 Columns PAGEREF _Toc255527002 \h 284
HYPERLINK \l "_Toc255527003" 3.1.4.2.2.1.3.10.2 Additional Restrictions PAGEREF _Toc255527003 \h 291
HYPERLINK \l "_Toc255527004" 3.1.4.2.2.1.3.11 MDSCHEMA_MEMBERS PAGEREF _Toc255527004 \h 291
HYPERLINK \l "_Toc255527005" 3.1.4.2.2.1.3.11.1 Columns PAGEREF _Toc255527005 \h 291
HYPERLINK \l "_Toc255527006" 3.1.4.2.2.1.3.11.2 Additional Restrictions PAGEREF _Toc255527006 \h 294
HYPERLINK \l "_Toc255527007" 3.1.4.2.2.1.3.12 MDSCHEMA_ACTIONS PAGEREF _Toc255527007 \h 295
HYPERLINK \l "_Toc255527008" 3.1.4.2.2.1.3.12.1 Columns PAGEREF _Toc255527008 \h 295
HYPERLINK \l "_Toc255527009" 3.1.4.2.2.1.3.12.2 Additional Restrictions PAGEREF _Toc255527009 \h 297
HYPERLINK \l "_Toc255527010" 3.1.4.2.2.1.3.12.3 Remarks PAGEREF _Toc255527010 \h 297
HYPERLINK \l "_Toc255527011" 3.1.4.2.2.1.3.13 MDSCHEMA_SETS PAGEREF _Toc255527011 \h 298
HYPERLINK \l "_Toc255527012" 3.1.4.2.2.1.3.13.1 Columns PAGEREF _Toc255527012 \h 298
HYPERLINK \l "_Toc255527013" 3.1.4.2.2.1.3.13.2 Additional Restrictions PAGEREF _Toc255527013 \h 299
HYPERLINK \l "_Toc255527014" 3.1.4.2.2.1.3.14 DISCOVER_INSTANCES PAGEREF _Toc255527014 \h 300
HYPERLINK \l "_Toc255527015" 3.1.4.2.2.1.3.14.1 Columns PAGEREF _Toc255527015 \h 300
HYPERLINK \l "_Toc255527016" 3.1.4.2.2.1.3.15 MDSCHEMA_KPIS PAGEREF _Toc255527016 \h 300
HYPERLINK \l "_Toc255527017" 3.1.4.2.2.1.3.15.1 Columns PAGEREF _Toc255527017 \h 301
HYPERLINK \l "_Toc255527018" 3.1.4.2.2.1.3.15.2 Additional Restrictions PAGEREF _Toc255527018 \h 303
HYPERLINK \l "_Toc255527019" 3.1.4.2.2.1.3.16 MDSCHEMA_MEASUREGROUPS PAGEREF _Toc255527019 \h 303
HYPERLINK \l "_Toc255527020" 3.1.4.2.2.1.3.16.1 Columns PAGEREF _Toc255527020 \h 303
HYPERLINK \l "_Toc255527021" 3.1.4.2.2.1.3.17 MDSCHEMA_MEASUREGROUP_DIMENSIONS PAGEREF _Toc255527021 \h 304
HYPERLINK \l "_Toc255527022" 3.1.4.2.2.1.3.17.1 Columns PAGEREF _Toc255527022 \h 304
HYPERLINK \l "_Toc255527023" 3.1.4.2.2.1.3.17.2 Additional Restrictions PAGEREF _Toc255527023 \h 306
HYPERLINK \l "_Toc255527024" 3.1.4.2.2.1.3.18 MDSCHEMA_INPUT_DATASOURCES PAGEREF _Toc255527024 \h 306
HYPERLINK \l "_Toc255527025" 3.1.4.2.2.1.3.18.1 Columns PAGEREF _Toc255527025 \h 306
HYPERLINK \l "_Toc255527026" 3.1.4.2.2.1.3.19 DMSCHEMA_MINING_SERVICES PAGEREF _Toc255527026 \h 307
HYPERLINK \l "_Toc255527027" 3.1.4.2.2.1.3.19.1 Columns PAGEREF _Toc255527027 \h 307
HYPERLINK \l "_Toc255527028" 3.1.4.2.2.1.3.20 DMSCHEMA_MINING_SERVICE_PARAMETERS PAGEREF _Toc255527028 \h 314
HYPERLINK \l "_Toc255527029" 3.1.4.2.2.1.3.20.1 Columns PAGEREF _Toc255527029 \h 314
HYPERLINK \l "_Toc255527030" 3.1.4.2.2.1.3.21 DMSCHEMA_MINING_FUNCTIONS PAGEREF _Toc255527030 \h 315
HYPERLINK \l "_Toc255527031" 3.1.4.2.2.1.3.21.1 Columns PAGEREF _Toc255527031 \h 315
HYPERLINK \l "_Toc255527032" 3.1.4.2.2.1.3.22 DMSCHEMA_MINING_MODEL_CONTENT PAGEREF _Toc255527032 \h 316
HYPERLINK \l "_Toc255527033" 3.1.4.2.2.1.3.22.1 Columns PAGEREF _Toc255527033 \h 316
HYPERLINK \l "_Toc255527034" 3.1.4.2.2.1.3.22.2 Additional Restrictions PAGEREF _Toc255527034 \h 322
HYPERLINK \l "_Toc255527035" 3.1.4.2.2.1.3.23 DMSCHEMA_MINING_MODEL_XML PAGEREF _Toc255527035 \h 322
HYPERLINK \l "_Toc255527036" 3.1.4.2.2.1.3.23.1 Columns PAGEREF _Toc255527036 \h 322
HYPERLINK \l "_Toc255527037" 3.1.4.2.2.1.3.24 DMSCHEMA_MINING_MODEL_CONTENT_PMML PAGEREF _Toc255527037 \h 324
HYPERLINK \l "_Toc255527038" 3.1.4.2.2.1.3.24.1 Columns PAGEREF _Toc255527038 \h 324
HYPERLINK \l "_Toc255527039" 3.1.4.2.2.1.3.25 DMSCHEMA_MINING_MODELS PAGEREF _Toc255527039 \h 325
HYPERLINK \l "_Toc255527040" 3.1.4.2.2.1.3.25.1 Columns PAGEREF _Toc255527040 \h 325
HYPERLINK \l "_Toc255527041" 3.1.4.2.2.1.3.26 DMSCHEMA_MINING_COLUMNS PAGEREF _Toc255527041 \h 328
HYPERLINK \l "_Toc255527042" 3.1.4.2.2.1.3.26.1 Columns PAGEREF _Toc255527042 \h 328
HYPERLINK \l "_Toc255527043" 3.1.4.2.2.1.3.27 DMSCHEMA_MINING_STRUCTURES PAGEREF _Toc255527043 \h 334
HYPERLINK \l "_Toc255527044" 3.1.4.2.2.1.3.27.1 Columns PAGEREF _Toc255527044 \h 335
HYPERLINK \l "_Toc255527045" 3.1.4.2.2.1.3.28 DMSCHEMA_MINING_STRUCTURE_COLUMNS PAGEREF _Toc255527045 \h 337
HYPERLINK \l "_Toc255527046" 3.1.4.2.2.1.3.28.1 Columns PAGEREF _Toc255527046 \h 337
HYPERLINK \l "_Toc255527047" 3.1.4.2.2.1.3.29 DISCOVER_PROPERTIES PAGEREF _Toc255527047 \h 343
HYPERLINK \l "_Toc255527048" 3.1.4.2.2.1.3.29.1 Columns PAGEREF _Toc255527048 \h 343
HYPERLINK \l "_Toc255527049" 3.1.4.2.2.1.3.30 DISCOVER_LITERALS PAGEREF _Toc255527049 \h 344
HYPERLINK \l "_Toc255527050" 3.1.4.2.2.1.3.30.1 Columns PAGEREF _Toc255527050 \h 344
HYPERLINK \l "_Toc255527051" 3.1.4.2.2.1.3.31 DISCOVER_SCHEMA_ROWSETS PAGEREF _Toc255527051 \h 346
HYPERLINK \l "_Toc255527052" 3.1.4.2.2.1.3.31.1 Columns PAGEREF _Toc255527052 \h 346
HYPERLINK \l "_Toc255527053" 3.1.4.2.2.1.3.32 DISCOVER_KEYWORDS PAGEREF _Toc255527053 \h 347
HYPERLINK \l "_Toc255527054" 3.1.4.2.2.1.3.32.1 Columns PAGEREF _Toc255527054 \h 347
HYPERLINK \l "_Toc255527055" 3.1.4.2.2.1.3.33 DISCOVER_DATASOURCES PAGEREF _Toc255527055 \h 347
HYPERLINK \l "_Toc255527056" 3.1.4.2.2.1.3.33.1 Columns PAGEREF _Toc255527056 \h 348
HYPERLINK \l "_Toc255527057" 3.1.4.2.2.1.3.34 DISCOVER_PROPERTIES PAGEREF _Toc255527057 \h 349
HYPERLINK \l "_Toc255527058" 3.1.4.2.2.1.3.34.1 Columns PAGEREF _Toc255527058 \h 349
HYPERLINK \l "_Toc255527059" 3.1.4.2.2.1.3.35 DISCOVER_ENUMERATORS PAGEREF _Toc255527059 \h 350
HYPERLINK \l "_Toc255527060" 3.1.4.2.2.1.3.35.1 Columns PAGEREF _Toc255527060 \h 350
HYPERLINK \l "_Toc255527061" 3.1.4.2.2.1.3.36 DISCOVER_XML_METADATA PAGEREF _Toc255527061 \h 351
HYPERLINK \l "_Toc255527062" 3.1.4.2.2.1.3.36.1 Columns PAGEREF _Toc255527062 \h 351
HYPERLINK \l "_Toc255527063" 3.1.4.2.2.1.3.36.2 Additional Restrictions PAGEREF _Toc255527063 \h 351
HYPERLINK \l "_Toc255527064" 3.1.4.2.2.1.3.37 DISCOVER_TRACES PAGEREF _Toc255527064 \h 353
HYPERLINK \l "_Toc255527065" 3.1.4.2.2.1.3.37.1 Columns PAGEREF _Toc255527065 \h 353
HYPERLINK \l "_Toc255527066" 3.1.4.2.2.1.3.38 DISCOVER_TRACE_DEFINITION_PROVIDERINFO PAGEREF _Toc255527066 \h 354
HYPERLINK \l "_Toc255527067" 3.1.4.2.2.1.3.38.1 Columns PAGEREF _Toc255527067 \h 354
HYPERLINK \l "_Toc255527068" 3.1.4.2.2.1.3.39 DISCOVER_TRACE_COLUMNS PAGEREF _Toc255527068 \h 354
HYPERLINK \l "_Toc255527069" 3.1.4.2.2.1.3.39.1 Columns PAGEREF _Toc255527069 \h 354
HYPERLINK \l "_Toc255527070" 3.1.4.2.2.1.3.40 DISCOVER_TRACE_EVENT_CATEGORIES PAGEREF _Toc255527070 \h 355
HYPERLINK \l "_Toc255527071" 3.1.4.2.2.1.3.40.1 Columns PAGEREF _Toc255527071 \h 355
HYPERLINK \l "_Toc255527072" 3.1.4.2.2.1.3.41 DISCOVER_MEMORYUSAGE PAGEREF _Toc255527072 \h 356
HYPERLINK \l "_Toc255527073" 3.1.4.2.2.1.3.41.1 Columns PAGEREF _Toc255527073 \h 356
HYPERLINK \l "_Toc255527074" 3.1.4.2.2.1.3.42 DISCOVER_MEMORYGRANT PAGEREF _Toc255527074 \h 357
HYPERLINK \l "_Toc255527075" 3.1.4.2.2.1.3.42.1 Columns PAGEREF _Toc255527075 \h 357
HYPERLINK \l "_Toc255527076" 3.1.4.2.2.1.3.43 DISCOVER_LOCKS PAGEREF _Toc255527076 \h 358
HYPERLINK \l "_Toc255527077" 3.1.4.2.2.1.3.43.1 Columns PAGEREF _Toc255527077 \h 359
HYPERLINK \l "_Toc255527078" 3.1.4.2.2.1.3.43.2 Additional Restrictions PAGEREF _Toc255527078 \h 360
HYPERLINK \l "_Toc255527079" 3.1.4.2.2.1.3.44 DISCOVER_CONNECTIONS PAGEREF _Toc255527079 \h 360
HYPERLINK \l "_Toc255527080" 3.1.4.2.2.1.3.44.1 Columns PAGEREF _Toc255527080 \h 361
HYPERLINK \l "_Toc255527081" 3.1.4.2.2.1.3.45 DISCOVER_SESSIONS PAGEREF _Toc255527081 \h 363
HYPERLINK \l "_Toc255527082" 3.1.4.2.2.1.3.45.1 Columns PAGEREF _Toc255527082 \h 363
HYPERLINK \l "_Toc255527083" 3.1.4.2.2.1.3.46 DISCOVER_JOBS PAGEREF _Toc255527083 \h 366
HYPERLINK \l "_Toc255527084" 3.1.4.2.2.1.3.46.1 Columns PAGEREF _Toc255527084 \h 366
HYPERLINK \l "_Toc255527085" 3.1.4.2.2.1.3.46.2 Additional Restrictions PAGEREF _Toc255527085 \h 367
HYPERLINK \l "_Toc255527086" 3.1.4.2.2.1.3.47 DISCOVER_TRANSACTIONS PAGEREF _Toc255527086 \h 368
HYPERLINK \l "_Toc255527087" 3.1.4.2.2.1.3.47.1 Columns PAGEREF _Toc255527087 \h 368
HYPERLINK \l "_Toc255527088" 3.1.4.2.2.1.3.48 DISCOVER_DB_CONNECTIONS PAGEREF _Toc255527088 \h 369
HYPERLINK \l "_Toc255527089" 3.1.4.2.2.1.3.48.1 Columns PAGEREF _Toc255527089 \h 369
HYPERLINK \l "_Toc255527090" 3.1.4.2.2.1.3.49 DISCOVER_MASTER_KEY PAGEREF _Toc255527090 \h 370
HYPERLINK \l "_Toc255527091" 3.1.4.2.2.1.3.49.1 Columns PAGEREF _Toc255527091 \h 370
HYPERLINK \l "_Toc255527092" 3.1.4.2.2.1.3.50 DISCOVER_PERFORMANCE_COUNTERS PAGEREF _Toc255527092 \h 371
HYPERLINK \l "_Toc255527093" 3.1.4.2.2.1.3.50.1 Columns PAGEREF _Toc255527093 \h 371
HYPERLINK \l "_Toc255527094" 3.1.4.2.2.1.3.51 DISCOVER_LOCATIONS PAGEREF _Toc255527094 \h 371
HYPERLINK \l "_Toc255527095" 3.1.4.2.2.1.3.51.1 Columns PAGEREF _Toc255527095 \h 371
HYPERLINK \l "_Toc255527096" 3.1.4.2.2.1.3.51.2 Additional Restrictions PAGEREF _Toc255527096 \h 373
HYPERLINK \l "_Toc255527097" 3.1.4.2.2.1.3.52 DISCOVER_PARTITION_DIMENSION_STAT PAGEREF _Toc255527097 \h 373
HYPERLINK \l "_Toc255527098" 3.1.4.2.2.1.3.52.1 Columns PAGEREF _Toc255527098 \h 373
HYPERLINK \l "_Toc255527099" 3.1.4.2.2.1.3.53 DISCOVER_PARTITION_STAT PAGEREF _Toc255527099 \h 374
HYPERLINK \l "_Toc255527100" 3.1.4.2.2.1.3.53.1 Columns PAGEREF _Toc255527100 \h 374
HYPERLINK \l "_Toc255527101" 3.1.4.2.2.1.3.54 DISCOVER_DIMENSION_STAT PAGEREF _Toc255527101 \h 375
HYPERLINK \l "_Toc255527102" 3.1.4.2.2.1.3.54.1 Columns PAGEREF _Toc255527102 \h 375
HYPERLINK \l "_Toc255527103" 3.1.4.2.2.1.3.55 DISCOVER_COMMANDS PAGEREF _Toc255527103 \h 376
HYPERLINK \l "_Toc255527104" 3.1.4.2.2.1.3.55.1 Columns PAGEREF _Toc255527104 \h 376
HYPERLINK \l "_Toc255527105" 3.1.4.2.2.1.3.56 DISCOVER_COMMAND_OBJECTS PAGEREF _Toc255527105 \h 377
HYPERLINK \l "_Toc255527106" 3.1.4.2.2.1.3.56.1 Columns PAGEREF _Toc255527106 \h 377
HYPERLINK \l "_Toc255527107" 3.1.4.2.2.1.3.57 DISCOVER_OBJECT_ACTIVITY PAGEREF _Toc255527107 \h 379
HYPERLINK \l "_Toc255527108" 3.1.4.2.2.1.3.57.1 Columns PAGEREF _Toc255527108 \h 379
HYPERLINK \l "_Toc255527109" 3.1.4.2.2.1.3.58 DISCOVER_OBJECT_MEMORY_USAGE PAGEREF _Toc255527109 \h 381
HYPERLINK \l "_Toc255527110" 3.1.4.2.2.1.3.58.1 Columns PAGEREF _Toc255527110 \h 381
HYPERLINK \l "_Toc255527111" 3.1.4.2.2.1.3.59 DISCOVER_STORAGE_TABLES PAGEREF _Toc255527111 \h 382
HYPERLINK \l "_Toc255527112" 3.1.4.2.2.1.3.59.1 Columns PAGEREF _Toc255527112 \h 382
HYPERLINK \l "_Toc255527113" 3.1.4.2.2.1.3.60 DISCOVER_STORAGE_TABLE_COLUMNS PAGEREF _Toc255527113 \h 383
HYPERLINK \l "_Toc255527114" 3.1.4.2.2.1.3.60.1 Columns PAGEREF _Toc255527114 \h 384
HYPERLINK \l "_Toc255527115" 3.1.4.2.2.1.3.61 DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS PAGEREF _Toc255527115 \h 387
HYPERLINK \l "_Toc255527116" 3.1.4.2.2.1.3.61.1 Columns PAGEREF _Toc255527116 \h 387
HYPERLINK \l "_Toc255527117" 3.1.4.2.2.2 DiscoverResponse PAGEREF _Toc255527117 \h 389
HYPERLINK \l "_Toc255527118" 3.1.4.2.2.2.1 Return Element PAGEREF _Toc255527118 \h 389
HYPERLINK \l "_Toc255527119" 3.1.4.3 Execute PAGEREF _Toc255527119 \h 389
HYPERLINK \l "_Toc255527120" 3.1.4.3.1 Messages PAGEREF _Toc255527120 \h 390
HYPERLINK \l "_Toc255527121" 3.1.4.3.1.1 ExecuteSoapIn PAGEREF _Toc255527121 \h 390
HYPERLINK \l "_Toc255527122" 3.1.4.3.1.2 ExecuteSoapOut PAGEREF _Toc255527122 \h 390
HYPERLINK \l "_Toc255527123" 3.1.4.3.2 Elements PAGEREF _Toc255527123 \h 390
HYPERLINK \l "_Toc255527124" 3.1.4.3.2.1 Execute PAGEREF _Toc255527124 \h 390
HYPERLINK \l "_Toc255527125" 3.1.4.3.2.1.1 Command Element PAGEREF _Toc255527125 \h 391
HYPERLINK \l "_Toc255527126" 3.1.4.3.2.1.1.1 ObjectReference Type PAGEREF _Toc255527126 \h 392
HYPERLINK \l "_Toc255527127" 3.1.4.3.2.1.1.2 Statement PAGEREF _Toc255527127 \h 393
HYPERLINK \l "_Toc255527128" 3.1.4.3.2.1.1.3 Create PAGEREF _Toc255527128 \h 394
HYPERLINK \l "_Toc255527129" 3.1.4.3.2.1.1.4 Alter PAGEREF _Toc255527129 \h 394
HYPERLINK \l "_Toc255527130" 3.1.4.3.2.1.1.5 Delete PAGEREF _Toc255527130 \h 395
HYPERLINK \l "_Toc255527131" 3.1.4.3.2.1.1.6 Process PAGEREF _Toc255527131 \h 396
HYPERLINK \l "_Toc255527132" 3.1.4.3.2.1.1.6.1 OutOfLineBinding PAGEREF _Toc255527132 \h 397
HYPERLINK \l "_Toc255527133" 3.1.4.3.2.1.1.7 MergePartitions PAGEREF _Toc255527133 \h 400
HYPERLINK \l "_Toc255527134" 3.1.4.3.2.1.1.8 DesignAggregations PAGEREF _Toc255527134 \h 401
HYPERLINK \l "_Toc255527135" 3.1.4.3.2.1.1.9 ClearCache PAGEREF _Toc255527135 \h 402
HYPERLINK \l "_Toc255527136" 3.1.4.3.2.1.1.10 Subscribe PAGEREF _Toc255527136 \h 402
HYPERLINK \l "_Toc255527137" 3.1.4.3.2.1.1.11 Cancel PAGEREF _Toc255527137 \h 402
HYPERLINK \l "_Toc255527138" 3.1.4.3.2.1.1.12 BeginTransaction PAGEREF _Toc255527138 \h 403
HYPERLINK \l "_Toc255527139" 3.1.4.3.2.1.1.13 CommitTransaction PAGEREF _Toc255527139 \h 403
HYPERLINK \l "_Toc255527140" 3.1.4.3.2.1.1.14 RollbackTransaction PAGEREF _Toc255527140 \h 404
HYPERLINK \l "_Toc255527141" 3.1.4.3.2.1.1.15 Lock PAGEREF _Toc255527141 \h 404
HYPERLINK \l "_Toc255527142" 3.1.4.3.2.1.1.16 Unlock PAGEREF _Toc255527142 \h 405
HYPERLINK \l "_Toc255527143" 3.1.4.3.2.1.1.17 Backup PAGEREF _Toc255527143 \h 405
HYPERLINK \l "_Toc255527144" 3.1.4.3.2.1.1.17.1 Location_Backup PAGEREF _Toc255527144 \h 406
HYPERLINK \l "_Toc255527145" 3.1.4.3.2.1.1.18 Restore PAGEREF _Toc255527145 \h 407
HYPERLINK \l "_Toc255527146" 3.1.4.3.2.1.1.18.1 Location PAGEREF _Toc255527146 \h 408
HYPERLINK \l "_Toc255527147" 3.1.4.3.2.1.1.18.2 Folder PAGEREF _Toc255527147 \h 408
HYPERLINK \l "_Toc255527148" 3.1.4.3.2.1.1.19 Synchronize PAGEREF _Toc255527148 \h 409
HYPERLINK \l "_Toc255527149" 3.1.4.3.2.1.1.19.1 Source PAGEREF _Toc255527149 \h 410
HYPERLINK \l "_Toc255527150" 3.1.4.3.2.1.1.20 Attach PAGEREF _Toc255527150 \h 410
HYPERLINK \l "_Toc255527151" 3.1.4.3.2.1.1.21 Detach PAGEREF _Toc255527151 \h 411
HYPERLINK \l "_Toc255527152" 3.1.4.3.2.1.1.22 Insert PAGEREF _Toc255527152 \h 411
HYPERLINK \l "_Toc255527153" 3.1.4.3.2.1.1.22.1 Object PAGEREF _Toc255527153 \h 411
HYPERLINK \l "_Toc255527154" 3.1.4.3.2.1.1.22.2 Attribute_InsertUpdate PAGEREF _Toc255527154 \h 412
HYPERLINK \l "_Toc255527155" 3.1.4.3.2.1.1.22.3 Translation_InsertUpdate PAGEREF _Toc255527155 \h 413
HYPERLINK \l "_Toc255527156" 3.1.4.3.2.1.1.23 Update PAGEREF _Toc255527156 \h 413
HYPERLINK \l "_Toc255527157" 3.1.4.3.2.1.1.23.1 Where PAGEREF _Toc255527157 \h 414
HYPERLINK \l "_Toc255527158" 3.1.4.3.2.1.1.23.2 Where_Attribute PAGEREF _Toc255527158 \h 414
HYPERLINK \l "_Toc255527159" 3.1.4.3.2.1.1.24 Drop PAGEREF _Toc255527159 \h 415
HYPERLINK \l "_Toc255527160" 3.1.4.3.2.1.1.25 UpdateCells PAGEREF _Toc255527160 \h 415
HYPERLINK \l "_Toc255527161" 3.1.4.3.2.1.1.25.1 Cell PAGEREF _Toc255527161 \h 416
HYPERLINK \l "_Toc255527162" 3.1.4.3.2.1.1.26 NotifyTableChange PAGEREF _Toc255527162 \h 417
HYPERLINK \l "_Toc255527163" 3.1.4.3.2.1.1.27 Batch PAGEREF _Toc255527163 \h 417
HYPERLINK \l "_Toc255527164" 3.1.4.3.2.1.2 Properties Element PAGEREF _Toc255527164 \h 419
HYPERLINK \l "_Toc255527165" 3.1.4.3.2.1.3 Parameters PAGEREF _Toc255527165 \h 419
HYPERLINK \l "_Toc255527166" 3.1.4.3.2.1.3.1 ExecuteParameter PAGEREF _Toc255527166 \h 420
HYPERLINK \l "_Toc255527167" 3.1.4.3.2.2 ExecuteResponse PAGEREF _Toc255527167 \h 420
HYPERLINK \l "_Toc255527168" 3.1.4.3.2.2.1 return Element PAGEREF _Toc255527168 \h 420
HYPERLINK \l "_Toc255527169" 3.1.5 Timer Events PAGEREF _Toc255527169 \h 421
HYPERLINK \l "_Toc255527170" 3.1.6 Other Local Events PAGEREF _Toc255527170 \h 421
HYPERLINK \l "_Toc255527171" 3.2 Transport-Specific Protocol Details PAGEREF _Toc255527171 \h 422
HYPERLINK \l "_Toc255527172" 3.2.1 Connection PAGEREF _Toc255527172 \h 422
HYPERLINK \l "_Toc255527173" 3.2.2 Authentication and Encryption PAGEREF _Toc255527173 \h 422
HYPERLINK \l "_Toc255527174" 3.2.3 Content Type Negotiation PAGEREF _Toc255527174 \h 422
HYPERLINK \l "_Toc255527175" 3.2.4 Generating and Parsing Messages PAGEREF _Toc255527175 \h 423
HYPERLINK \l "_Toc255527176" 3.2.5 Compression PAGEREF _Toc255527176 \h 424
HYPERLINK \l "_Toc255527177" 4 Protocol Examples PAGEREF _Toc255527177 \h 426
HYPERLINK \l "_Toc255527178" 4.1 Client Obtains a List of Databases from the Server over TCP PAGEREF _Toc255527178 \h 426
HYPERLINK \l "_Toc255527179" 4.1.1 Connection PAGEREF _Toc255527179 \h 426
HYPERLINK \l "_Toc255527180" 4.1.2 Authentication PAGEREF _Toc255527180 \h 426
HYPERLINK \l "_Toc255527181" 4.1.3 New Session Request PAGEREF _Toc255527181 \h 430
HYPERLINK \l "_Toc255527182" 4.1.4 Request for List of Catalogs PAGEREF _Toc255527182 \h 433
HYPERLINK \l "_Toc255527183" 4.1.5 End of Session PAGEREF _Toc255527183 \h 436
HYPERLINK \l "_Toc255527184" 4.2 Client Obtains a List of Cubes from the Server over HTTP PAGEREF _Toc255527184 \h 438
HYPERLINK \l "_Toc255527185" 4.2.1 Connection PAGEREF _Toc255527185 \h 439
HYPERLINK \l "_Toc255527186" 4.2.2 New Session Request PAGEREF _Toc255527186 \h 439
HYPERLINK \l "_Toc255527187" 4.2.3 Request for List of Cubes PAGEREF _Toc255527187 \h 440
HYPERLINK \l "_Toc255527188" 4.2.4 End of Session PAGEREF _Toc255527188 \h 441
HYPERLINK \l "_Toc255527189" 4.3 Client Obtains a List of Measures from the Server PAGEREF _Toc255527189 \h 442
HYPERLINK \l "_Toc255527190" 4.3.1 Client Sends Request PAGEREF _Toc255527190 \h 442
HYPERLINK \l "_Toc255527191" 4.3.2 Server Response PAGEREF _Toc255527191 \h 443
HYPERLINK \l "_Toc255527192" 4.4 Client Obtains a List of Properties from the Server PAGEREF _Toc255527192 \h 445
HYPERLINK \l "_Toc255527193" 4.4.1 Client Sends Request PAGEREF _Toc255527193 \h 445
HYPERLINK \l "_Toc255527194" 4.4.2 Server Response PAGEREF _Toc255527194 \h 445
HYPERLINK \l "_Toc255527195" 4.5 Client Obtains a List of Mining Models from the Server PAGEREF _Toc255527195 \h 461
HYPERLINK \l "_Toc255527196" 4.5.1 Client Sends Request PAGEREF _Toc255527196 \h 461
HYPERLINK \l "_Toc255527197" 4.5.2 Server Response PAGEREF _Toc255527197 \h 462
HYPERLINK \l "_Toc255527198" 4.6 Client Obtains a List of Traces from the Server PAGEREF _Toc255527198 \h 462
HYPERLINK \l "_Toc255527199" 4.6.1 Client Sends Request PAGEREF _Toc255527199 \h 462
HYPERLINK \l "_Toc255527200" 4.6.2 Server Response PAGEREF _Toc255527200 \h 463
HYPERLINK \l "_Toc255527201" 4.7 Client Obtains a List of Connections from the Server PAGEREF _Toc255527201 \h 463
HYPERLINK \l "_Toc255527202" 4.7.1 Client Sends Request PAGEREF _Toc255527202 \h 463
HYPERLINK \l "_Toc255527203" 4.7.2 Server Response PAGEREF _Toc255527203 \h 464
HYPERLINK \l "_Toc255527204" 4.8 Client Obtains a List of Locks from the Server PAGEREF _Toc255527204 \h 466
HYPERLINK \l "_Toc255527205" 4.8.1 Client Sends Request PAGEREF _Toc255527205 \h 466
HYPERLINK \l "_Toc255527206" 4.8.2 Server Response PAGEREF _Toc255527206 \h 467
HYPERLINK \l "_Toc255527207" 4.9 Client Obtains a List of Commands from the Server PAGEREF _Toc255527207 \h 471
HYPERLINK \l "_Toc255527208" 4.9.1 Client Sends Request PAGEREF _Toc255527208 \h 471
HYPERLINK \l "_Toc255527209" 4.9.2 Server Response PAGEREF _Toc255527209 \h 472
HYPERLINK \l "_Toc255527210" 4.10 Client Obtains Trace Provider Information PAGEREF _Toc255527210 \h 473
HYPERLINK \l "_Toc255527211" 4.10.1 Client Sends Request PAGEREF _Toc255527211 \h 473
HYPERLINK \l "_Toc255527212" 4.10.2 Server Response PAGEREF _Toc255527212 \h 474
HYPERLINK \l "_Toc255527213" 4.11 Client Obtains List of Trace Column Definitions PAGEREF _Toc255527213 \h 475
HYPERLINK \l "_Toc255527214" 4.11.1 Client Sends Request PAGEREF _Toc255527214 \h 475
HYPERLINK \l "_Toc255527215" 4.11.2 Server Response PAGEREF _Toc255527215 \h 476
HYPERLINK \l "_Toc255527216" 4.12 Client Obtains List of Trace Event Categories PAGEREF _Toc255527216 \h 484
HYPERLINK \l "_Toc255527217" 4.12.1 Client Sends Request PAGEREF _Toc255527217 \h 484
HYPERLINK \l "_Toc255527218" 4.12.2 Server Response PAGEREF _Toc255527218 \h 485
HYPERLINK \l "_Toc255527219" 4.13 Client Sends MDX Query and Receives Back mddataset Result PAGEREF _Toc255527219 \h 555
HYPERLINK \l "_Toc255527220" 4.13.1 Client Sends Request PAGEREF _Toc255527220 \h 555
HYPERLINK \l "_Toc255527221" 4.13.2 Server Response PAGEREF _Toc255527221 \h 555
HYPERLINK \l "_Toc255527222" 4.14 Create PAGEREF _Toc255527222 \h 622
HYPERLINK \l "_Toc255527223" 4.14.1 Client Sends Request PAGEREF _Toc255527223 \h 622
HYPERLINK \l "_Toc255527224" 4.14.2 Server Response PAGEREF _Toc255527224 \h 685
HYPERLINK \l "_Toc255527225" 4.15 Alter PAGEREF _Toc255527225 \h 685
HYPERLINK \l "_Toc255527226" 4.15.1 Client Sends Request PAGEREF _Toc255527226 \h 685
HYPERLINK \l "_Toc255527227" 4.15.2 Server Response PAGEREF _Toc255527227 \h 686
HYPERLINK \l "_Toc255527228" 4.16 Delete PAGEREF _Toc255527228 \h 687
HYPERLINK \l "_Toc255527229" 4.16.1 Client Sends Request PAGEREF _Toc255527229 \h 687
HYPERLINK \l "_Toc255527230" 4.16.2 Server Response PAGEREF _Toc255527230 \h 687
HYPERLINK \l "_Toc255527231" 4.17 Process PAGEREF _Toc255527231 \h 687
HYPERLINK \l "_Toc255527232" 4.17.1 Client Sends Request PAGEREF _Toc255527232 \h 687
HYPERLINK \l "_Toc255527233" 4.17.2 Server Response PAGEREF _Toc255527233 \h 687
HYPERLINK \l "_Toc255527234" 4.18 Backup PAGEREF _Toc255527234 \h 688
HYPERLINK \l "_Toc255527235" 4.18.1 Client Sends Request PAGEREF _Toc255527235 \h 688
HYPERLINK \l "_Toc255527236" 4.18.2 Server Response PAGEREF _Toc255527236 \h 688
HYPERLINK \l "_Toc255527237" 4.19 Restore PAGEREF _Toc255527237 \h 688
HYPERLINK \l "_Toc255527238" 4.19.1 Client Sends Request PAGEREF _Toc255527238 \h 688
HYPERLINK \l "_Toc255527239" 4.19.2 Server Response PAGEREF _Toc255527239 \h 689
HYPERLINK \l "_Toc255527240" 4.20 Begin Transaction PAGEREF _Toc255527240 \h 689
HYPERLINK \l "_Toc255527241" 4.20.1 Client Sends Request PAGEREF _Toc255527241 \h 689
HYPERLINK \l "_Toc255527242" 4.20.2 Server Response PAGEREF _Toc255527242 \h 689
HYPERLINK \l "_Toc255527243" 4.21 Commit Transaction PAGEREF _Toc255527243 \h 690
HYPERLINK \l "_Toc255527244" 4.21.1 Client Sends Request PAGEREF _Toc255527244 \h 690
HYPERLINK \l "_Toc255527245" 4.21.2 Server Response PAGEREF _Toc255527245 \h 690
HYPERLINK \l "_Toc255527246" 4.22 Rollback Transaction PAGEREF _Toc255527246 \h 690
HYPERLINK \l "_Toc255527247" 4.22.1 Client Sends Request PAGEREF _Toc255527247 \h 690
HYPERLINK \l "_Toc255527248" 4.22.2 Server Response PAGEREF _Toc255527248 \h 691
HYPERLINK \l "_Toc255527249" 5 Security PAGEREF _Toc255527249 \h 692
HYPERLINK \l "_Toc255527250" 5.1 Security Considerations for Implementers PAGEREF _Toc255527250 \h 692
HYPERLINK \l "_Toc255527251" 5.2 Index of Security Parameters PAGEREF _Toc255527251 \h 692
HYPERLINK \l "_Toc255527252" 6 Appendix A: Full WSDL PAGEREF _Toc255527252 \h 693
HYPERLINK \l "_Toc255527253" 7 Appendix B: Product Behavior PAGEREF _Toc255527253 \h 694
HYPERLINK \l "_Toc255527254" 8 Change Tracking PAGEREF _Toc255527254 \h 725
HYPERLINK \l "_Toc255527255" 9 Index PAGEREF _Toc255527255 \h 736
1 Introduction
The [MS-SSAS]: SQL Server Analysis Services Protocol Specification describes the SQL Server Analysis Services Protocol, which provides methods for a client to communicate with, and perform operations on, an analysis server.
1.1 Glossary
The following terms are defined in HYPERLINK "[MS-GLOS].pdf"[MS-GLOS]:
Component Object Model (COM)data manipulation language (DML)language code identifier (LCID)paddingsecurity tokenSOAP actionSOAP bodySOAP faultSOAP headerSOAP messageWSDL message
The following terms are defined in HYPERLINK "[MS-OFCGLOS].pdf"[MS-OFCGLOS]:
complex typedata blockdata definition language (DDL)MIME typemultidimensional expression (MDX)Online Analytical Processing (OLAP)simple typeslicer axistupleuniform resource identifier (URI)XML namespaceXML Schema
The following terms are specific to this document:
action: OLAP objects, such as Cubes, Dimensions, and Cells, can have an action associated with them, so that users can perform that action when browsing OLAP data. For example, users can jump to a URL, execute a command, or drill through to data.
analysis server: A server that provides both OLAP and data mining (DM) services.
assembly: A managed application module containing class metadata and managed code as an object in SQLServer, against which common language runtime (CLR) functions, stored procedures, triggers, user-defined aggregates, and user-defined types can be created in SQLServer.
balanced hierarchy: A dimension hierarchy in which all leaf nodes are the same distance from the root node.
cube: A set of data that is organized and summarized into a multidimensional structure defined by a set of dimensions and measures.
dimension: A structural attribute of a cube, which is an organized hierarchy of categories (levels) that describe data in the fact table.
hierarchy: A logical tree structure that organizes the members of a dimension such that each member has one parent member and zero or more child members.
Database Mining Extensions (DMX): A syntax that is used for defining data mining objects and for querying and manipulating data mining data.
key attribute: The attribute of a dimension that links the non-key attributes in the dimension to related measures.
lazy aggregations: Aggregations that are rebuilt by the server in the background after the processing step has been completed, instead of during the processing step. This is the process that underlies expressions, such as partitions that are "lazily processed," and aggregations and indexes that are "built lazily."
level: The name of a set of members in a dimension hierarchy, such that all members of the set are at the same distance from the root of the hierarchy.
locale identifier (LCID): A number that identifies a Windows-based locale.
measure: In a cube, a set of values that are usually numeric and are based on a column in the fact table of the cube. Measures are the central values that are aggregated and analyzed.
measure group: All the measures in a cube that derive from a single fact table in a data source view.
mining model: An object that contains the definition of a data mining process and the results of the training activity.
mining structure: A data mining object that defines the data domain from which the mining models are built.
partition: One of the storage containers for data and aggregations of a cube. Every cube contains one or more partitions. For a cube with multiple partitions, each partition can be stored separately in a different physical location. Each partition can be based on a different data source. Partitions are not visible to users; the cube appears to be a single object.
permission: A rule associated with an object to regulate which users can gain access to the object and in what manner.Permissions are tracked separately for different objects; specifically, Databases, Data Sources, Dimensions, Mining Structures, Mining Models, and Cubes.
proactive caching: A system that manages data obsolescence in a cube by which objects in MOLAP storage are automatically updated and processed in the cache, while queries are redirected to ROLAP storage.
remote partition: A partition whose data is stored on a server that is running an instance of SQL Server Analysis Services, other than the one used to store the metadata of the partition.
repeated base: A base column where the trace provider can reference previous data and therefore omit resending a column again to SQL Server Profiler. The client tool keeps track of all repeatable columns for each new repeated-base column value.
role-playing dimension: A single database dimension joined to the fact table on a different foreign key to produce multiple cube dimensions.
unbalanced hierarchy: A hierarchy in which one or more levels do not contain members in one or more branches of the hierarchy. This is also known as a ragged hierarchy.
MAY, SHOULD, MUST, SHOULD NOT, MUST NOT: These terms (in all caps) are used as described in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90317"[RFC2119]. All statements of optional behavior use either MAY, SHOULD, or SHOULD NOT.
1.2 References
1.2.1 Normative References
We conduct frequent surveys of the normative references to assure their continued availability. If you have any issue with finding a normative reference, please contact HYPERLINK "mailto:dochelp@microsoft.com"dochelp@microsoft.com. We will assist you in finding the relevant information. Please check the archive site, HYPERLINK "http://msdn2.microsoft.com/en-us/library/E4BD6494-06AD-4aed-9823-445E921C9624"http://msdn2.microsoft.com/en-us/library/E4BD6494-06AD-4aed-9823-445E921C9624, as an additional source.
[DIME] Nielsen, H. F., Sanders, H., and Christensen, E., "Direct Internet Message Encapsulation (DIME)", February 2002, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=89847"http://xml.coverpages.org/draft-nielsen-dime-01.txt
[MS-BINXML] Microsoft Corporation, "SQL Server Binary XML Structure Specification", HYPERLINK "[MS-BINXML].pdf"http://msdn.microsoft.com/en-us/library/ee208875.aspx.
[MS-GLOS] Microsoft Corporation, "HYPERLINK "[MS-GLOS].pdf"Windows Protocols Master Glossary", March 2007.
[MS-LCID] Microsoft Corporation, "HYPERLINK "[MS-LCID].pdf"Windows Language Code Identifier (LCID) Reference", July 2007.
[MS-OFCGLOS] Microsoft Corporation, "HYPERLINK "[MS-OFCGLOS].pdf"Microsoft Office Master Glossary".
[MS-OFSGLOS] See [MS-OFCGLOS].
[RFC793] Postel, J., "Transmission Control Protocol", STD 7, RFC 793, September 1981, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90493"http://www.ietf.org/rfc/rfc0793.txt
[RFC2279] Yergeau, F., "UTF-8, A Transformation Format of ISO10646", RFC 2279, January 1998, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90331"http://www.ietf.org/rfc/rfc2279.txt
[RFC2396] Berners-Lee, T., Fielding, R., and Masinter, L., "Uniform Resource Identifiers (URI): Generic Syntax", RFC 2396, August 1998, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90339"http://www.ietf.org/rfc/rfc2396.txt
[RFC2616] Fielding, R., Gettys, J., Mogul, J., et al., "Hypertext Transfer Protocol -- HTTP/1.1", RFC 2616, June 1999, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90372"http://www.ietf.org/rfc/rfc2616.txt
[RFC2743] Linn, J., "Generic Security Service Application Program Interface Version 2, Update 1", RFC 2743, January 2000, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90378"http://www.ietf.org/rfc/rfc2743.txt
[RFC2818] Rescorla, E., "HTTP Over TLS", RFC 2818, May 2000, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90383"http://www.ietf.org/rfc/rfc2818.txt
[RFC4178] Zhu, L., Leach, P., Jaganathan, K., and Ingersoll, W., "The Simple and Protected Generic Security Service Application Program Interface (GSS-API) Negotiation Mechanism", RFC 4178, October 2005, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90461"http://www.ietf.org/rfc/rfc4178.txt
[SOAP1.1] Box, D., Ehnebuske, D., Kakivaya, G., Layman, A., Mendelsohn, N., Nielsen, H. F., Thatte, S., and Winer, D., "Simple Object Access Protocol (SOAP) 1.1", May 2000, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90520"http://www.w3.org/TR/2000/NOTE-SOAP-20000508/
[SOAP1.2-1/2007] Gudgin, M., Hadley, M., Mendelsohn, N., Moreau, J. J., Nielsen, H. F., Karmarkar, A. and Lafon, Y., "SOAP Version 1.2 Part 1: Messaging Framework (Second Edition) ", W3C Recommendation 27, April 2007, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=94664"http://www.w3.org/TR/2007/REC-soap12-part1-20070427/
[SOAP1.2-2/2007] Gudgin, M., Hadley, M., Mendelsohn, N., Moreau, J. J., Nielsen, H. F., Karmarkar, A. and Lafon, Y., "SOAP Version 1.2 Part 2: Adjuncts (Second Edition)", W3C Recommendation, April 2007, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=119124"http://www.w3.org/TR/2007/REC-soap12-part2-20070427
[WSDL] Christensen, E., Curbera, F., Meredith, G., and Weerawarana, S., "Web Services Description Language (WSDL) 1.1", W3C Note, March 2001, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90577"http://www.w3.org/TR/2001/NOTE-wsdl-20010315
[XML10] World Wide Web Consortium, "Extensible Markup Language (XML) 1.0 (Third Edition)", February 2004, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90600"http://www.w3.org/TR/REC-xml
[XMLNS3] World Wide Web Consortium, "Namespaces in XML 1.0 (Third Edition)", December 2009, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=183354"http://www.w3.org/TR/2009/REC-xml-names-20091208/
[XMLSCHEMA1] Thompson, H.S., Ed., Beech, D., Ed., Maloney, M., Ed., and Mendelsohn, N., Ed., "XML Schema Part 1: Structures", W3C Recommendation, May 2001, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90608"http://www.w3.org/TR/2001/REC-xmlschema-1-20010502/
[XMLSCHEMA2] Biron, P.V., Ed. and Malhotra, A., Ed., "XML Schema Part 2: Datatypes", W3C Recommendation, May 2001, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90610"http://www.w3.org/TR/2001/REC-xmlschema-2-20010502/
[W3C-XSD] World Wide Web Consortium, "XML Schema Part 2: Datatypes Second Edition", October 2004, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90563"http://www.w3.org/TR/2004/REC-xmlschema-2-20041028/
[RFC2119] Bradner, S., "Key words for use in RFCs to Indicate Requirement Levels", BCP 14, RFC 2119, March 1997, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90317"http://www.ietf.org/rfc/rfc2119.txt
1.2.2 Informative References
[MSDN-ASSL] Microsoft Corporation, "RefreshInterval Element (ASSL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=157484"http://msdn.microsoft.com/en-us/library/ms126689.aspx
[MSDN-DDRXSD] Microsoft Corporation, "Deriving DataSet Relational Structure from XML Schema (XSD)", HYPERLINK "http://msdn.microsoft.com/en-us/library/bfdchewb.aspx"http://msdn.microsoft.com/en-us/library/bfdchewb.aspx
[MSDN-FDPR] Microsoft Corporation, "Flattening a Dataset to Produce a Rowset", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=157106"http://msdn.microsoft.com/en-us/library/ms716948(VS.85).aspx
[MSDN-FSCMDX] Microsoft Corporation, "FORMAT_STRING Contents (MDX)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=152511"http://msdn.microsoft.com/en-us/library/ms146084.aspx
[MSDN-LCASMD] Microsoft Corporation, "Languages and Collations (Analysis Services - Multidimensional Data)", HYPERLINK " http://go.microsoft.com/fwlink/?LinkId=157107"http://msdn.microsoft.com/en-us/library/ms174872.aspx
[MSDN-MDXR] Microsoft Corporation, "Multidimensional Expressions (MDX) Reference", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=156776"http://msdn.microsoft.com/en-us/library/ms145506.aspx
[MSDN-OLEDB] Microsoft Corporation, "Microsoft OLE DB", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90054"http://msdn.microsoft.com/en-us/library/ms722784.aspx
[MSDN-SLNL] Microsoft Corporation, "Support Level for Named Levels", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=157108"http://msdn.microsoft.com/en-us/library/ms714938(VS.85).aspx
[MSDN-SSAS] Microsoft Corporation, "Analysis Services Concepts and Objects", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=165649"http://msdn2.microsoft.com/en-us/library/ms174578.aspx
[MSDN-SQLXML] Microsoft Corporation, "SQLXML", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=157110"http://msdn.microsoft.com/en-us/library/aa286527.aspx
[XMLA] Microsoft Corporation, Hyperion Solutions Corporation, SAS Institute Inc., "XML for Analysis", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=157111"http://www.xmla.org/xmla1.1.doc
1.3 Protocol Overview (Synopsis)
The [MS-SSAS]: SQL Server Analysis Services Protocol Specification provides methods for a client to communicate with, and perform operations on, an HYPERLINK \l "z2"analysis server. This protocol is based on SOAP and XML for Analysis (XMLA) HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=113990"[XMLA]. This protocol supports TCP/IP as an underlying transport mechanism in addition to HTTP/HTTPS.
The SQL Server Analysis Services Protocol Specification defines the following operations: Authenticate, Discover, and Execute.
Authenticate is used by the client and server to exchange UTF-8 (HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90331"[RFC2279]) encoded HYPERLINK "[MS-GLOS].pdf"security token data blocks as part of the authentication process. For more information on authentication, see section HYPERLINK \l "z772a1badda7246c9a4068cee8ba99277"4.1.2.
Discover is used to obtain information from an analysis server, such as a list of catalogs on a server. Properties are used to control what data is obtained. This generic interface and the use of properties allow extensibility without rewriting existing functions. For more information, see section HYPERLINK \l "z49346daa9c9b4188a9feee267768b253"3.1.4.2.
Execute is used to execute commands against a particular analysis server and optionally get back a result set either in a tabular or multidimensional form. For more information, see section HYPERLINK \l "zd2b8314d7a174bf182c2db3cd467bc17"3.1.4.3.
By using the Authenticate, Discover, and Execute operations, the transfer of data between a client and an analysis server can be achieved.
The following diagram illustrates this concept:
Figure 1: Data transfer between a client and an analysis server via the Authenticate, Discover, and Execute operations
1.4 Relationship to Other Protocols
The SQL Server Analysis Services Protocol uses the SOAP messaging protocol for formatting requests and responses as specified either in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90520"[SOAP1.1] or in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=94664"[SOAP1.2-1/2007] and HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=119124"[SOAP1.2-2/2007]. It transmits these messages using HTTP HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90372"[RFC2616], HTTPS HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90383"[RFC2818], or TCP HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90493"[RFC793].
This protocol uses SOAP over HTTP, as shown in the following layering diagram:
Figure 2: SOAP over HTTP
The SQL Server Analysis Services Protocol uses SOAP over HTTPS, as shown in the following diagram:
Figure 3: SOAP over HTTPS
The SQL Server Analysis Services Protocol uses SOAP over Direct Internet Message Encapsulation HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=89847"[DIME] and TCP/IP, as shown in the following diagram:
Figure 4: SOAP over DIME and TCP/IP
1.5 Prerequisites/Preconditions
None.
1.6 Applicability Statement
This protocol supports the exchange of messages between a client and an analysis server.
1.7 Versioning and Capability Negotiation
1.7.1 Versioning
This protocol includes capabilities for a client and a server to exchange versioning information by indicating whether XML elements which are sent or received must be understood, or, if not understood, may be ignored. This is specified in section HYPERLINK \l "z91987baf3e5f48dfb3578299f137cd44"2.2.4.2.1.3.
1.7.2 Capability Negotiation
This protocol does explicit negotiation between the client and the server for use of binary XML and compression, as specified in section HYPERLINK \l "zf172a52ff69e40518b3a627433e978fb"2.1.1.
1.8 Vendor-Extensible Fields
None.
1.9 Standards Assignments
None.
2 Messages
2.1 Transport
The communication between a client and a server MUST be performed either over TCP or HTTP/HTTPS. The message format is a clear text XML HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90600"[XML10] or binary XML HYPERLINK "[MS-BINXML].pdf"[MS-BINXML] that MAY be compressed. The message MAY also be encrypted by using GSS-API HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90461"[RFC4178] over TCP or SSL over HTTPS.
In addition, DIME HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=89847"[DIME] is used for messages transmitted using TCP, and all data transferred between client and server is encoded by using UTF-8 HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90331"[RFC2279]. Section HYPERLINK \l "zefb5c3b3d09a4b8e9503d1fd65836f9c"2.2 specifies the HYPERLINK "[MS-GLOS].pdf"SOAP message syntax, regardless of the underlying transport.
Unless otherwise specified, this protocol uses network byte order (big-endian) for all data.
2.1.1 TCP
When using TCP as the transport, the client and server MUST compose messages using DIME HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=89847"[DIME]. A DIME message consists of one or more DIME records. Each DIME message MAY optionally be broken into smaller records.HYPERLINK \l "z26"<1>
The following table describes the layout of a DIME record.
FieldDescriptionVERSION (5 bits)Specifies the version of the DIME message.MB (1 bit)Specifies that this record is the first record of the message.ME (1 bit)Specifies that this record is the last record of the message.CF (1 bit)Specifies that the contents of the message have been broken into smaller records.TYPE_T (4 bits)Specifies whether the DIME record is the first record of a DIME message.RESERVED (4 bits)The behavior of this field is undefined (must be set to 0).HYPERLINK \l "z28"<2>OPTIONS_LENGTH (16 bits)Specifies the length (in bytes) of the OPTIONS field, excluding any necessary HYPERLINK "[MS-GLOS].pdf"padding (up to 3 bytes). Padding consists of bytes that are inserted in a data stream to maintain alignment of the protocol requests on natural boundaries.ID_LENGTH (16 bits)Specifies the length (in bytes) of the ID field, excluding any necessary padding (up to 3 bytes).TYPE_LENGTH (16 bits)Specifies the length (in bytes) of the TYPE field, excluding any necessary padding (up to 3 bytes).DATA_LENGTH (32 bits)Specifies the length (in bytes) of the DATA field, excluding any necessary padding (up to 3 bytes).OPTIONSContains any optional information used by a DIME parserIDContains a HYPERLINK "[MS-OFCGLOS].pdf"uniform resource identifier (URI) for uniquely identifying a DIME payload with any additional padding. The length of this field is specified by ID_LENGTH. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=96641"[RFC2396].TYPESpecifies the encoding for the record based on a type reference URI or a MIME media-type. The reference type is specified by TYPE_T, and the length of this field is specified by TYPE_LENGTH. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90339"[RFC2396].DATAContains the actual data payload for the record. The format of the data depends on the TYPE specified for the record. The length of this field is specified by DATA_LENGTH.The VERSION field (5 bits) is used to identify the internal version of DIME parser that is used by both parties. This value MUST be set to 1.
The MB field (1 bit) MUST be set to 1 for every DIME record that is beginning a new DIME message and MUST be set to 0 for all consecutive DIME records.
The ME field (1 bit) MUST be set to 1 for every DIME record that is a last record of every DIME message and MUST be set to 0 for all other DIME records.
The CF field (1 bit) MUST be set to 1 for every chunked DIME record except for the last record. Every chunked sequence is required to be encapsulated entirely within one DIME message and cannot span across multiple DIME messages. Therefore, a first or a middle record MUST NOT have the ME field value set to 1.
The TYPE_T field (4 bits) MUST be set to 1 for every DIME record that is beginning a new DIME message and MUST be set to 0 for all consecutive DIME records.
This protocol allows the optional use of binary XML HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90603"[MS-BINXML] and compression that the client or server SHOULD apply on the SOAP request or response to reduce network latency. The content types that are supported are described in the following table.HYPERLINK \l "z30"<3>
TYPE_LENGTHTYPEDescription8text/xmlData content is clear text XML.14application/sxData content is binary XML.22application/xml+xpressData content is compressed XML.21application/sx+xpressData content is compressed binary XML.Because the support for binary XML and compression is optional, the client and server MUST negotiate the content type of the messages for the duration of the connection. This is done using flags in the OPTIONS field. The OPTIONS field consists of 4 bytes of which only the first byte is used. The last three bytes are reserved and MUST be set to zero. The following table describes the bits in the first byte in order from the least significant bit to the most significant bit.
BitDescriptionNEGOSpecifies whether message content type negotiation is complete.REQ_SXSpecifies whether request from the client should or will be binary XML.REQ_XPRESSSpecifies whether request from the client should or will be compressed.RESP_SXSpecifies whether response from the server should or will be binary XML.RESP_XPRESSSpecifies whether response from the server should or will be compressed.RESERVEDBehavior is undefined (MUST be set to 0).RESERVEDBehavior is undefined (MUST be set to 0).RESERVEDBehavior is undefined (MUST be set to 0).2.1.2 HTTP/HTTPS
When using HTTP/HTTPS as the transport, the client and server MUST set the HTTP headers that are described in the following table.
FieldDescriptionSOAPActionSpecifies HYPERLINK "[MS-GLOS].pdf"SOAP action type "urn:schemas-microsoft-com:xml-analysis:Discover" for HYPERLINK \l "z49346daa9c9b4188a9feee267768b253"Discover requests or "urn:schemas-microsoft-com:xml-analysis:Execute" for HYPERLINK \l "zd2b8314d7a174bf182c2db3cd467bc17"Execute requests.X-Transport-Caps-Negotiation-FlagsUsed for content type negotiation. The value is a comma-separated list of five values that correspond to NEGO, REQ_SX, REQ_XPRESS, RESP_SX, and RESP_XPRESS.Content-TypeSpecifies the content type of the payload. The value is one of the following:
"text/xml"
"application/sx"
"application/xml+xpress"
"application/sx+xpress"2.1.3 Encryption
When using TCP as the transport, the client and server SHOULD choose to encrypt or hash messages using HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90378"[RFC2743]. This is negotiated at the time of authentication after which the client and server can use GSS-API to determine whether encryption or hashing is enabled for the connection.
If encryption or hashing is being used, the message can be composed of one or more encryption data blocks. Each encryption data block has a layout as described in the following table.
FieldDescriptionDATA_SIZE (16 bit)Specifies the size of the encrypted data. This field uses little-endian byte order.TOKEN_SIZE (16 bit)Specifies the size of the encryption token. This field uses little-endian byte order.DATAEncrypted data.TOKENEncryption token.Note that an encryption data block can span multiple DIME records.
2.1.4 Compression
When using TCP or HTTP/HTTPS as the transport, the client and server SHOULD choose to compress messages. This is first negotiated when the connection is established.
If compression is being used, the message can be composed of one or more compression data blocks. Each compression data block has a layout as described in the following table.
FieldDescriptionORIGINAL_SIZE (32 bit)Specifies the original size of the data. This field uses little-endian byte order.COMPRESSED_SIZE (32 bit)Specifies the size of the data after compression. This field uses little-endian byte order.DATACompressed data.ORIGINAL_SIZE (32 bit)Specifies the original size of the data. This field uses little-endian byte order.Note that a compression data block can span multiple DIME records or encryption data blocks.
2.1.5 Binary XML
When using TCP or HTTP/HTTPS as the transport, the client and server SHOULD choose to encode messages in binary XML HYPERLINK "[MS-BINXML].pdf"[MS-BINXML]. This is first negotiated when the connection is established.
The following table lists the binary XML data types that are supported in this protocol. The client and server MUST NOT use data types outside this list.
XSD TypeBinary XML Typexsd:booleanXSD-BOOLEANxsd:byteSQL-TINYINTxsd:shortSQL-SMALLINTxsd:intSQL-INTxsd:longSQL-BIGINTxsd:unsignedByteXSD-UNSIGNEDBYTExsd: unsignedShortXSD-UNSIGNEDSHORTxsd: unsignedIntXSD-UNSIGNEDINTxsd: unsignedLongXSD-UNSIGNEDLONGxsd:doubleSQL-REALxsd:floatSQL-FLOATxsd:decimalSQL-MONEYxsd:dateTimeSQL-DATETIMEuuidSQL-UUIDxsd:stringSQL-NTEXT
SQL-NCHAR
SQL-NVARCHARxsd:base64BinarySQL-BINARY2.2 Common Message Syntax
This section contains common definitions used by this protocol. The syntax of the definitions uses HYPERLINK "[MS-OFCGLOS].pdf"XML Schema as defined in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90608"[XMLSCHEMA1] and HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90610"[XMLSCHEMA2], and Web Services Description Language (WSDL) as defined in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90577"[WSDL].
2.2.1 Namespaces
This specification defines and references various HYPERLINK "[MS-OFCGLOS].pdf"XML namespaces using the mechanisms that are specified in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=183354"[XMLNS3]. Although this specification associates a specific XML namespace prefix for each XML namespace that is used, the choice of any particular XML namespace prefix is implementation-specific and not significant for interoperability.
This section contains common definitions used by this protocol. The syntax of the definitions uses XML Schema as defined in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90608"[XMLSCHEMA1] and HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=145501"[XMLSCHEMA2], and Web Services Description Language as defined in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90577"[WSDL].
PrefixNamespace URIReferencexsdHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=158697"http://www.w3.org/2001/XMLSchemaHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90608" [XMLSCHEMA1]
HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=145501"[XMLSCHEMA2]xsiHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=158696"http://www.w3.org/2001/XMLSchema-instanceHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90608"[XMLSCHEMA1]
HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=145501"[XMLSCHEMA2]Sqlurn:schemas-microsoft-com:xml-sqlHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=31174 "[MSDN-SQLXML]xmlaurn:schemas-microsoft-com:xml-analysisHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=113990"[XMLA]xmla-dsurn:schemas-microsoft-com:xml-analysis:mddatasetHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=113990"[XMLA]xmla-rsurn:schemas-microsoft-com:xml-analysis:rowsetHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=113990"[XMLA]xmla-eurn:schemas-microsoft-com:xml-analysis:emptyHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=113990"[XMLA]xmla-xurn:schemas-microsoft-com:xml-analysis:exceptionHYPERLINK "http://go.microsoft.com/fwlink/?LinkId=113990"[XMLA]xmla-mhttp://schemas.microsoft.com/analysisservices/2003/xmla-multipleresultsenghttp://schemas.microsoft.com/analysisservices/2003/engineeng2http://schemas.microsoft.com/analysisservices/2003/engine/2eng2_2http://schemas.microsoft.com/analysisservices/2003/engine/2/2eng100http://schemas.microsoft.com/analysisservices/2008/engine/100eng100_100http://schemas.microsoft.com/analysisservices/2008/engine/100/100eng200http://schemas.microsoft.com/analysisservices/2010/engine/200eng200_200http://schemas.microsoft.com/analysisservices/2010/engine/200/2002.2.2 Messages
This specification does not define any common XML Schema message definitions.
2.2.3 Elements
This specification does not define any common XML Schema element definitions.
2.2.4 Complex Types
The following table summarizes the set of common XML Schema HYPERLINK "[MS-OFCGLOS].pdf"complex type definitions defined by this specification. XML Schema complex type definitions that are specific to a particular operation are described with the operation.
Complex TypeDescriptionxmla-mddatasetDescribes data from a HYPERLINK \l "z5"cube in a representation consisting of information about the origin of the data, the axes of the cube and the data cells.xmla-emptyresultDescribes a response to an exception that has occurred at the server during the process of the client request and no further data is available to the client.xmla-rowsetDescribes data from a cube in a tabular representation.xmla-x:messagesDescribes the structure of error and warning messages sent by the server to the client.2.2.4.1 Return Value Complex Types
2.2.4.1.1 xmla-ds:mddataset Complex Type
An xmla-ds:mddataset type is the type that is returned by commands that return an mddataset as the return result.
The XML Schema Definition (XSD) complex type definition for the xmla-ds:mddataset complex type is as follows.
ElementDescriptionSchemaAn XSD schema that describes the rest of the result.OlapInfoDescribes the structure of the OLAP elements of this result.AxesContains the axes of the result.CellDataContains the cell data of the result.ExceptionThis optional element is returned if there are exceptions that accompany the result. See section HYPERLINK \l "z0f9ccf3d05d74b4397c3a3037b1ec2f1"2.2.4.1.4.MessagesThis optional element is returned if there are messages that accompany the result. See section HYPERLINK \l "z0f9ccf3d05d74b4397c3a3037b1ec2f1"2.2.4.1.4.An example of the mddataset return type is shown in section HYPERLINK \l "zf9bdaa97c8a34667b4621e1e51461dd2"4.13.
2.2.4.1.1.1 xmla-ds:OlapInfo Complex Type
The OlapInfo type contains information describing the multidimensional data that is sent in a specific response. It MUST contain information about the cube or cubes from which these results were extracted, information about all axes involved, and data for the cells returned.
The xmla-ds:OlapInfo complex type describes the current schema definition for the result set requested by the client. The OlapInfo complex type contains the description of the specific structure of the data that is returned. The result set is described in three major sections:
C u b e I n f o : D e s c r i b e s t h e s o u r c e o f t h e r e s u l t s e t .
A x e s I n f o : D e s c r i b e s t h e d a t a s t r u c t u r e o f a l l a x e s i n t h e r e s u l t s e t , i n c l u d i n g t h e H Y P E R L I N K " [ M S - O F C G L O S ] . p d f " s l i c e r a x i s .
C e l l I n f o : D e s c r i b e s t h e d a t a s t r u c t u r e f o r t h e c e l l s .
T h e c o m p l e x t y p e d efinition for OlapInfo is as follows. The OlapInfo element, and all its contained elements, are in the namespace xmla-ds.
ElementDescriptionCubeInfoContains information about the cubes for this result.AxesInfoDescribes the axes that will be in the Axes element of this response.CellInfoDescribes the cells that will be in the CellData element of this response.2.2.4.1.1.1.1 xmla-ds:CubeInfo
The CubeInfo complex type describes all the sources that are involved in providing the current result set.
ElementDescriptionCubeA collection of elements of type OlapInfoCube, which contains information about the cubes for this result.2.2.4.1.1.1.1.1 OlapInfoCube
This complex type contains information about the cubes returned in an mddataset result.
The Dimension XSD depends upon element definitions in namespaces other than the default namespace. The following elements are defined in the namespace eng:
ElementDescriptionCubeNameThe name of the cube.LastDataUpdateLast date and time that the cube data was updated.LastSchemaupdateLast date and time that the cube schema was updated.2.2.4.1.1.1.2 xmla-ds:AxesInfo
The AxesInfo complex type describes the axes that will be contained in the Axes element of the mddataset result.
ElementDescriptionAxisInfoContains the description of the axes that will appear in the Axes element of this mddataset.2.2.4.1.1.1.2.1 xmla-ds:AxisInfo
The AxisInfo type describes a single axis that will appear in the Axes section of a particular mddataset return result.
ElementDescriptionHierarchyInfoA collection of HierarchyInfo elements is returned.
AttributeDescriptionNameThe Name of the axis that is being described.2.2.4.1.1.1.2.1.1 xmla-ds:HierarchyInfo
The HierarchyInfo type contains information about the hierarchies that appear on an axis of an mddataset return result.
ElementDescriptionxsd:anyThe contents of the HierarchyInfo element varies according to the contents of the axis that is being described. There will be one child element within HierarchyInfo for each property that is returned on the axis being described. The number of properties returned is variable and depends upon the query that has been executed.
AttributeDescriptionNameThe Name of the HYPERLINK \l "z7"hierarchy that is being described.2.2.4.1.1.1.3 xmla-ds:CellInfo Complex Type
The CellInfo complex type describes the properties of a data cell that will appear in the CellData section of a specific mddataset return result.
ElementDescriptionxsd:anyThis complex type is a variable number of elements of type xsd:any. There will be one element for each property that is returned in the CellData section of this mddataset result. The number of elements present depends upon the number of properties that were requested in the query that was executed.The elements returned also have the following XML attributes, with the following interpretations.
AttributeDescriptionNameThe Name of the property on the server. This name may not be the same as the element name.TypeThe type that the element in the CellData section of the mddataset result will have.2.2.4.1.1.2 xmla-ds:Axes Complex Type
The xmla-ds:Axes complex type contains the values and properties of each member in the hierarchy of an axis in the mddataset result.
ElementDescriptionAxisAn Axis element contains the values for one axis of an mddataset result.2.2.4.1.1.2.1 Axis
An Axis element contains the values for one axis of an mddataset result.
The SetType model group is described in section HYPERLINK \l "z77c73f3559a64c91807c3733b1cd67da"2.2.4.1.1.2.1.1.
AttributeDescriptionNameThe name of the axis.2.2.4.1.1.2.1.1 SetType Model Group
The SetType model group describes the possible types of sets that belong to the group. For more information about model groups, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90608"[XMLSCHEMA1].
Each set type in the group is described independently in its own section:
H Y P E R L I N K \ l " z 3 0 d 6 b 4 e c 4 8 1 f 4 2 7 4 b 0 5 2 e 9 5 2 5 8 8 9 1 5 9 c " M e m b e r s T y p e c o m p l e x t y p e
H Y P E R L I N K \ l " z 7 3 e b 3 0 b 7 a 4 4 c 4 7 b 1 a f 7 9 1 3 1 9 e c 2 c 6 b 9 0 " T u p l e s T y p e c o m p l e x t y p e
H Y P E R L I N K \ l " z 2 0 e c 0 3 2 f 1 5 2 d 4 d a d b 0 f d 3 9 6 b b c 6 0 6 f 5 4 " S e t L i s t T y p e c o m p l e x T y p e
H Y P E R L I N K \ l " z 5 7 e 9 6 00165f24b60be364b4f54c3ffd5"msxmla:NormTupleSet complex Type
The Union subelement is an invocation of the SetType model group defined in section HYPERLINK \l "z4b951396fdb94434a68a83cff27cb7f4"2.2.4.1.3.1.1.HYPERLINK \l "z32"<4>
2.2.4.1.1.2.1.1.1 MembersType Complex Type
The MembersType complex type is a collection of MemberType elements. For more information, see section HYPERLINK \l "z5096442d0e6e481a87e9cc9383674248"2.2.4.1.1.2.1.1.2.
AttributeDescriptionHierarchyThe Hierarchy of the member.2.2.4.1.1.2.1.1.2 MemberType Complex Type
The MemberType type describes the properties of a simple element in the axis hierarchy. For example, in the Year:Quarter:Month:MonthDay axis HYPERLINK \l "z6"dimension, the member type describes the Year, the Quarter, the Month, or the MonthDay member of the hierarchy.
The schema definition of the MemberType type is defined in the AxisInfo specification of this message.
ElementDescriptionxsd:anyThe memberType will contain one element for each property of the member that was requested in the query. Therefore, both the content and the count of elements in the MemberType are variable.
AttributeDescriptionHierarchyThe Hierarchy of the member.2.2.4.1.1.2.1.1.3 TuplesType Complex Type
The TuplesType complex type is a collection of TupleType elements. For more information, see section HYPERLINK \l "z48dc96b97a2b474f8ae7608e663f6491"2.2.4.1.1.2.1.1.4.
2.2.4.1.1.2.1.1.4 TupleType Complex Type
The TupleType type describes the set of members that identifies a point in the axis hierarchy. A TupleType type is a collection of MemberType objects.
ElementDescriptionMemberA collection of MemberType elements that form the HYPERLINK "[MS-OFCGLOS].pdf"tuples along this axis of the mddataset result.2.2.4.1.1.2.1.1.5 SetListType Complex Type
A SetListType type describes a complex type composed of elements that belong to the SetType group.
2.2.4.1.1.2.1.1.5.1 msxmla:NormTupleSet Complex Type
The msxmla:NormTupleSet type provides an optimized format for a TupleSet. This format is used when the DbPropMsmdOptimizeResponse property is appropriately set (see section HYPERLINK \l "z52e0b880e2ff49cdb42edb99b39faa54"3.1.4.2.2.1.2.1).
2.2.4.1.1.3 xmla-ds:CellData Complex Type
The CellData type describes a collection of Cell elements. The Cell element describes the properties of a single cell of data.
The schema definition for the Cell element is defined in the CellInfo element specification of the current instance of this message.
2.2.4.1.1.3.1 CellOrdinal Attribute
The CellOrdinal attribute MUST be specified and indicates the ordinal of the cell. CellOrdinal is numbered 0 to n-1, for n cells.
The axis reference for a cell can be calculated based on CellOrdinal. Conceptually, cells are numbered in a dataset as if the dataset were a p-dimensional array, where p is the number of axes. Cells are addressed in row-major order. The following illustration shows the formula for calculating the ordinal number of a cell.
Figure 5: Calculating ordinal number of a cell
The preceding formula will be applied to the result set shown in the following table. The query asked for four HYPERLINK \l "z13"measures on columns and a crossjoin of two states with four quarters on rows. In the following dataset result, the CellOrdinal property for the part of the dataset result shown in the box is the set {9, 10, 11, 13, 14, 15, 17, 18, 19}. This is because the cells are numbered in row-major order, starting with a CellOrdinal of zero for the upper left cell.
Next, the preceding formula is applied to the cell that is {CA, Q3, Store Cost}. Axis k=0 has Uk=4 members and axis k=1 has Uk=8 tuples. P is the total number of axes in the query, here equal to 2. So, the initial summation is i=0 to 1. For i=0, the tuple ordinal on axis 0 of {Store Cost} is 1. For i = 1, the tuple ordinal of {CA, Q3} is 2.
For i=0, Ei = 1, so for i = 0 the sum is 1 * 1 = 1 and for i=1, the sum is 2 (tuple ordinal) * 4 (the value of Ei, computed as 1 * 4), or 8, and so the sum is equal to 1 + 8 = 9, the cell ordinal for that cell.
Unit SalesStore CostStore SalesSales CountCAQ116,890.0014,431.09$36,175.205498Q218,052.0015,332.02$38,396.755915Q318,370.0015,672.83$39,394.056014Q421,436.0018,094.50$45,201.847015ORQ119,287.0016,081.07$40,170.296184Q215,079.0012,678.96$31,772.884799Q316,940.0014,273.78$35,880.465432Q416,353.0013,738.68$34,453.4451962.2.4.1.1.3.2 Cell Value Errors
Whenever an error occurs trying to return the value of a cell, the server sends an Error element, inside the Value element of the cell, describing the error. For more information about the corresponding grammar, see section HYPERLINK \l "zd9b958bcc01b4fbea5b924cacb989fb6"2.2.4.1.1.3.
The following sample shows a security error when the user tried to get results from a cell to which he or she has restricted access.
2148497527
Security Error.
|
2.2.4.1.2 xmla-e:emptyresult Complex Type
The xmla-e:emptyresult complex type is returned if the return result is empty.
The XSD for the xmla-e:emptyresult complex type is as follows.
ElementDescriptionExceptionThis optional element is returned if there are exceptions that accompany the empty result. See section HYPERLINK \l "z9c674538a8c5455394a01db68d8ab6a9"2.2.4.1.5.1.MessagesThis optional element is returned if there are messages that accompany the empty result. See section HYPERLINK \l "z3461061211db46e3ad94ef245a927fd7"2.2.4.1.5.2.2.2.4.1.3 xmla-rs:rowset Complex Type
The xmla-rs:rowset complex type is returned by commands whose return result is a rowset. The XSD for the xmla-rs:rowset complex type is as follows.
ElementDescriptionSchemaAn optional XSD schema that describes the format of the row. Whether it is returned depends on the value of the Content server property. See section HYPERLINK \l "z8cac5d1aaeaa4bd09279c06f7f70f0b5"4.4.2.rowContains the rows with the results.ExceptionThis optional element is returned if there are exceptions that accompany the empty result. See section HYPERLINK \l "z860014a95c854f38bd6b3c5c1d4403a1"2.2.4.1.3.MessagesThis optional element is returned if there are messages that accompany the empty result. See section HYPERLINK \l "z860014a95c854f38bd6b3c5c1d4403a1"2.2.4.1.3.2.2.4.1.3.1 xmla-rs:row Complex Type
Each row element represents a row of tabular data.
ElementDescriptionxsd:anyThe content of each row is variable. Each element within each row can be thought of as a column in a tabular return result. There will be one element in each row to represent one column in a tabular presentation. The Schema element within the rs:root element can be used to obtain a dictionary of elements that will appear within each row, and the types of the elements. Additional rows may be nested within a row result, to a single level. See section HYPERLINK \l "z4b951396fdb94434a68a83cff27cb7f4"2.2.4.1.3.1.1 for information on nested rows.2.2.4.1.3.1.1 Nested Rowsets
A special case of the row element is where it is part of a nested rowset, and therefore contains the contents of an additional row. This can be thought of as "a row within a row." However, the nested row does not contain a new Row element. The limit of nesting is to one level. That is, nested rows cannot contain additional nested rows.
The nested rowset does not have a specific XSD. That is because the XSD definition for the xmla-rs:row element is xsd:any, and therefore, the concept of nested rows is included within the XSD definition of xmla-rs:row. However, the restriction is imposed that nesting is limited to one level.
This concept is best illustrated by a fragment of an example. The following code shows the return result of one row from the DISCOVER_SCHEMA_ROWSETS Discover.
DBSCHEMA_CATALOGS
C8B52211-5CF3-11CE-ADE5-00AA0044773D
CATALOG_NAME
xsd:string
1
Note that the Restrictions column of the above row contains a nested row within it. The nested row itself contains two elements, Name and Type. If a return result of xmla-rs:root contains a rowset with nested rows, this is reflected in the Schema element of the particular xmla-rs:rowset return result.
2.2.4.1.4 xmla-m:results Complex Type
The xmla-m:multipleresults complex type is returned only as a response to a Batch command. The results element contains one or more root elements, one that corresponds to each command that was executed within the Batch command. See section HYPERLINK \l "zb6fe7bf3bff344cf9506a114b72792b3"3.1.4.3.2.2.1 for a description of the root element and of the different types for the root element.
ElementDescriptionRootOne or more xmla-e:root elements are contained by the results element. One xmla-e:root element is returned for each command result in the Batch command stream.2.2.4.1.5 Error and Warning Complex Types
2.2.4.1.5.1 xmla-x:Exception
The xmla-x:Exception complex type is used when the server encounters an error during execution. This element MUST be empty. The XSD for the xmla-x:Exception type is as follows.
2.2.4.1.5.2 xmla-x:Messages
Any of the root elements may contain a messages element.
ElementDescriptionWarningInformation about the Warning.ErrorInformation about the Error.2.2.4.1.5.2.1 WarningType
The XSD for the WarningType complex type is as follows.
ElementDescriptionLocationLocation information for the Warning or Error.
AttributeDescriptionWarningCodeThe warning code for the Warning.DescriptionA description of the Warning.SourceThe source of the Warning, such as a product name.HelpFileA help file that contains information about the Warning.2.2.4.1.5.2.1.1 MessageLocation
The MessageLocation type is used to identify the line and column location of a warning or an error within a Statement element.
The XSD for the MessageLocation complex type is as follows.
The MessageLocation XSD depends on the following definitions in a namespace other than the default namespace.
The following elements are defined in the eng200 namespace.
ElementDescriptionStartThe Start element contains a Line element (integer) and a Column element (integer) that indicates the starting point of the Warning or Error.EndThe End element contains a Line element (integer) and a Column element (integer) that indicates the ending point of the Warning or Error.LineOffsetThe number of characters from the beginning of the stream to the beginning of the Start line.TextLengthNumber of characters in the message location, between Start and End.SourceObjectThe SourceObject is the object that has the error. The WarningLocation object represents either a column or a measure.DependsOnObjectThe DependsOnObject is the object on which the SourceObject depends in the case of a dependency error. The WarningLocation object represents either a column or a measure.DimensionIdentifies the Dimension of the SourceObject or DependsOnObject.AttributeIdentifies the Attribute of the SourceObject or DependsOnObject.CubeIdentifies the Cube of the SourceObject or DependsOnObject.MeasureGroupIdentifies the MeasureGroup of the SourceObject or DependsOnObject.MeasureNameIdentifies the MeasureName of the SourceObject or DependsOnObject.RowNumberFor calculation errors, the RowNumber in which the error occurred is provided.2.2.4.2 Object Definition Complex Types
An XML payload is sent to the server within the Create command (see section HYPERLINK \l "z812812082e24420882a6f43f99879626"3.1.4.3.2.1.1.3) or the Alter command (see section HYPERLINK \l "z374a42e43a0c4eb0ae9f6650e23704f3"3.1.4.3.2.1.1.4) to describe the objects on a server to be created or altered. Each server object is represented by a complex type in the commands that are sent to the server. The entire hierarchy of the complex types that comprise the available hierarchy of objects is described in this section.
All types defined in this section are in the namespace eng: unless otherwise specified.
2.2.4.2.1 Rules that Apply to All Complex Types
There are some rules that apply to all of the complex types enumerated in this section. This subsection enumerates rules that apply across all of the complex types.
2.2.4.2.1.1 Names, IDs, and References
Every structural object contains the following properties, as described in the subsequent sections under each complex type description.
A N a m e . N a m e s o f s i b l i n g o b j e c t s M U S T b e u n i q u e , w i t h i n s o m e s c o p e . T h e s c o p e i s g e n e r a l l y w i t h i n t h e p a r e n t c o l l e c t i o n . A n y e x c e p t i o n s t o t h i s a r e s t a t e d i n t h e f o l l o w i n g , u n d e r t h e d e s c r i p t i o n f o r t h e c o m p l e x t y p e . N a m e i s w h a t i s e x p o s e d t o c l i e n t p r o g r a m m e r s i n t h e s c h e m a r o w s e t s .
A n I D . T h e s a m e r e s t r i c t i o n s o n u n i q u e n e s s a p p l y t o I D s . I n a d d i t i o n , t h e y a r e n o t c h a n g e a b l e . T h e y a r e a s s i g n e d u p o n c r e a t i o n , e i t h e r b y t h e u s e r / t o o l , o r a u t o m a t i c a l l y b y t h e e n g i n e ( i f n o t s p e c i f i e d ) t o t h e i n i t i a l n a m e o f t h e o b j e c t . I D i s c o n s i d e r e d a m a n a g e m e n t p r o p e r t y . I D i s n o t e x p o s e d i n t h e s c h e m a r o w s e t f o r c l i e n t p r o g r a m m i n g .
A D e s c r i p t i o n .
S Q L S e r v e r A n a l y s i s S e r v i c e s h a s a d d i t i o n a l r u l e s t h a t a p p l y t o n a m e s a n d I D s . H Y P E R L I N K \ l " z 3 4 " <