This topic has not yet been rated - Rate this topic

Name Element (ASSL)

SQL Server 2005

Contains the name of the parent element.


<Action> <!-- or one of the elements listed below in the Element Relationships table -->
   ...
   <Name>...</Name>
   ...
</Action>

Element Characteristics

Characteristic	Description
Data type and length	String (up to 100 characters)
Default value	Varies
Cardinality	1-1: Required element that occurs once and only once

Element Relationships

Relationship	Element
Parent elements	Action, Aggregation, AggregationDesign, AlgorithmParameter, Annotation, Assembly, ClrAssemblyFile, Cube, CubeDimension, CubeHierarchy, Database, DataSource, DataSourceView, Dimension, DimensionAttribute, Group, Hierarchy, Kpi, Level, MdxScript, Measure, MeasureGroup, MemberProperty, MiningModel, MiningModelColumn, MiningStructure, MiningStructureColumn, Partition, Permission, Perspective, PerspectiveCalculation, ReportFormatParameter, ReportParameter, Role, Server, ServerProperty, Trace
Child elements	None

Relationship

Element

Parent elements

Action, Aggregation, AggregationDesign, AlgorithmParameter, Annotation, Assembly, ClrAssemblyFile, Cube, CubeDimension, CubeHierarchy, Database, DataSource, DataSourceView, Dimension, DimensionAttribute, Group, Hierarchy, Kpi, Level, MdxScript, Measure, MeasureGroup, MemberProperty, MiningModel, MiningModelColumn, MiningStructure, MiningStructureColumn, Partition, Permission, Perspective, PerspectiveCalculation, ReportFormatParameter, ReportParameter, Role, Server, ServerProperty, Trace

Child elements

None

Remarks

Every element that is used to define an object (an instance of Microsoft SQL Server 2005 Analysis Services (SSAS), a hierarchy, an attribute, and so on) has a Name element as a property. The value of a Name element has the following restrictions:

The value cannot contain leading or trailing spaces. If leading or trailing spaces are included in the value of a Name element, those spaces will be implicitly removed by Analysis Services.
The value cannot contain control characters. If control characters are included in the value of a Name element, those characters will be implicitly removed by Analysis Services.
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 a Name element, depending on the parent element.

Parent element	Invalid Characters
Server	The name must follow the rules for Microsoft Windows computer names. IP addresses are not valid.
DataSource	:/\*\|?"()[]{}<>
Level, Attribute Element	.,;'`:/\*\|?"&%$!+=[]{}<>
All other parent elements	.,;'`:/\*\|?"&%$!+=()[]{}<>

Reference

ID Element (ASSL)
Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD