1 out of 1 rated this helpful - Rate this topic

Object Element (XMLA)

SQL Server 2012

Contains an object reference used by the parent element.


<Alter> <!-- or any of the parent elements in the Element Relationships table -->
...
   <Object>
      <!-- One or more object identifiers, depending on the parent element -->
   </Object>
...
</Alter>

Element Characteristics

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

Ancestor or Parent	Cardinality
Alter	0-1: Optional element that can occur once and only once.
All others	1-1: Required element that occurs once and only once.

Element Relationships

Relationship	Element
Parent elements	Alter, Backup, ClearCache, Delete, DesignAggregations, Lock, NotifyTableChange, Process, Subscribe, Synchronize
Child elements	Required Analysis Services Scripting Language (ASSL) elements. Specified by listing the ID elements of the object and its ancestors (excluding the Server object.) For example, the following Object element identifies a partition: <Object> <DatabaseID>Adventure Works DW Multidimensional 2012</DatabaseID> <CubeID>Adventure Works</CubeID> <MeasureGroupID>Internet Sales</MeasureGroupID> <PartitionID>Inernet_Sales_2001</PartitionID> </Object>

Relationship

Element

Parent elements

Alter, Backup, ClearCache, Delete, DesignAggregations, Lock, NotifyTableChange, Process, Subscribe, Synchronize

Child elements

Required Analysis Services Scripting Language (ASSL) elements. Specified by listing the ID elements of the object and its ancestors (excluding the Server object.) For example, the following Object element identifies a partition:

<DatabaseID>Adventure Works DW Multidimensional 2012</DatabaseID>

<CubeID>Adventure Works</CubeID>

<MeasureGroupID>Internet Sales</MeasureGroupID>

<PartitionID>Inernet_Sales_2001</PartitionID>

</Object>

Remarks

The order in which identifiers appear is not important.

For Alter elements, the instance of Microsoft SQL Server Analysis Services is used as the default object if the Object element is not specified.

Concepts

Properties (XMLA)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD