ID Element (ASSL)

Contains the unique identifier (ID) of the parent element.


<Action> <!-- or one of the elements listed in the Element Relationships table -->

Element Characteristics

Characteristic Description

Data type and length

String (up to 100 characters)

Default value



0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

Action, Aggregation, AggregationDesign, Assembly, Cube, CubeBinding, CubeDimension, Database, DataSource, DataSourceView, Dimension, DimensionAttribute, Hierarchy, Kpi, Level, MdxScript, Measure, MeasureGroup, MeasureGroupBinding, MiningModel, MiningModelColumn, MiningStructure, MiningStructureColumn, Partition, Permission, Perspective, Role, Server, Trace

Child elements



Every major object in Microsoft SQL Server 2005 Analysis Services (SSAS) has an ID element as a property. The value of an ID element has the following restrictions:

  • The value cannot contain leading or trailing spaces. Analysis Services will implicitly remove leading or trailing spaces from the value of an ID element.
  • The value cannot contain control characters. Analysis Services will implicitly remove control characters from the value of an ID element.
  • The following reserved values cannot be used:
    • AUX
    • CLOCK$
    • COM1 through COM9 (COM1, COM2, COM3, and so on)
    • CON
    • LPT1 through LPT9 (LPT1, LPT2, LPT3, and so on)
    • NUL
    • PRN

The following table lists additional characters that cannot be used within the value of an ID element, depending on the parent element.

Parent element Characters


The value must follow the rules for Microsoft Windows computer names. (IP addresses are not valid.)



Level, Attribute Element


All other parent elements


See Also


Name Element (ASSL)
Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance