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 None
Cardinality 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 None


Every major object in Microsoft SQL Server Analysis Services 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
Server The value must follow the rules for Microsoft Windows computer names. (IP addresses are not valid.)
DataSource :/\*|?"()[]{}<>
Level, Attribute Element .,;'`:/\*|?"&%$!+=[]{}<>
All other parent elements .,;'`:/\*|?"&%$!+=()[]{}<>

See Also

Name Element (ASSL)
Properties (ASSL)