SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Analysis Services)
XMLA Reference
XML Elements (XMLA)
Properties
AllowOverwrite Element
ApplyCompression Element
Attribute Element
AttributeName Element
Attributes Element
Axes Element
AxesInfo Element
Axis Element
AxisInfo Element
BackupRemotePartitions Element
Binding Element
Bindings Element
CancelAssociated Element
Capability Element
Caption Element
Cell Element
Cell Element (MDDataSet)
CellData Element
CellInfo Element
CellOrdinal Element
Command Element
ConnectionID Element
ConnectionString Element
CrossProduct Element
Cube Element
Cube Element (OlapInfo)
CubeID Element
CubeInfo Element
CubeName Element
CustomRollup Element
CustomRollupProperties Element
Database Element
DatabaseID Element
DatabaseName Element
DataSource Element
DataSourceID Element
DataSourceType Element
DataSourceView Element
DbSchemaName Element
DbStorageLocation Element
DbTableName Element
DeleteWithDescendants Element
Description Element
Dimension Element
DisplayInfo Element
Error Element
ErrorCode Element
ErrorConfiguration Element
Exception Element
File Element
Folder Element
Folders Element
HelpFile Element
HierarchyInfo Element
ID Element
Keys Element
Key Element
Language Element
LastDataUpdate Element
LastSchemaUpdate Element
LName Element
LNum Element
Location Element
Locations Element
Materialize Element
MeasureGroupID Element
Member Element
Members Element
Message Element
Messages Element
Mode Element
MoveWithDescendants Element
Name Element
Name Element (Parameter)
New Element
Object Element
Object Element (Dimension)
ObjectDefinition Element
OlapInfo Element
Optimization Element
Original Element
Parallel Element
Parameter Element
Parameters Element
ParentObject Element
PartitionID Element
Password Element
Properties Element
PropertyList Element
Queries Element
Query Element
ReadWriteMode Element
RequestType Element
RestrictionList Element
Restrictions Element
results Element
return Element
Role Element
root Element
row Element
Security Element
SessionID Element
SkippedLevels Element
Source Element
Source Element (Error)
Source Element (Synchronize)
Sources Element
SPID Element
Steps Element
Storage Element
SynchronizeSecurity Element
TableNotification Element
TableNotifications Element
Target Element
Time Element
Translation Element
Translations Element
Tuple Element
Tuples Element
Type Element
UName Element
UnaryOperator Element
Value Element
Value Element (Parameter)
Warning Element
Where Element
WritebackTableCreation Element
FolderPosition Element
DefaultDetailsPosition Element
DisplayKeyPosition Element
CommonIdentifierPosition Element
IsDefaultMeasure Element
IsDefaultImage Element
SortPropertiesPosition Element
ContextualNameRule Element
EditionId Element
ServerMode Element
ProductLabel Element
Expand Minimize
This topic has not yet been rated - Rate this topic

Caption Element (XMLA)

SQL Server 2012

Contains information about the caption of the parent HierarchyInfo or Member element.

Xml
Copy 

<HierarchyInfo> <!-- or Member -->
   ...
   <Caption>...</Caption>
   ...
</HierarchyInfo>

Characteristic

Description

Data type and length

String

Default value

None

Cardinality

1-1: Required element that occurs once and only once.

Relationship

Element

Parent elements

HierarchyInfo, Member

Child elements

None

For HierarchyInfo elements, the Caption element contains the name of the property that provides the member captions of the hierarchy. The value is equivalent to the MEMBER_CAPTION property defined for axis rowsets in the OLE DB for OLAP specification.

For Member elements, the Caption element contains the caption of the parent Member element in the language specified for the XML for Analysis (XMLA) session. If no caption is available, this element contains the unique name of the member.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.