ID Element (ASSL)


Applies To: SQL Server 2016 Preview

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

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

Data type and lengthString (up to 100 characters)
Default valueNone
Cardinality0-1: Optional element that can occur once and only once.
Parent elementsAction, 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 elementsNone

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

Name Element (ASSL)
Properties (ASSL)

Community Additions