SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Analysis Services)

Analysis Services Scripting Language XML Elements (ASSL)

Objects

Account Element

Aggregation Element

AggregationDesign Element

AggregationInstance Element

AlgorithmParameter Element

AllMemberTranslation Element

Annotation Element

Assembly Element

Attribute Element

AttributeAllMemberTranslation Element

AttributePermission Element

AttributeRelationship Element

Block Element

Calculation Element

CalculationProperty Element

CaptionColumn Element

CellPermission Element

Command Element

Cube Element

CubePermission Element

CustomRollupColumn Element

CustomRollupPropertiesColumn Element

Data Element

Database Element

DatabasePermission Element

DataSource Element

DataSourcePermission Element

DataSourceView Element

Dimension Element

DimensionPermission Element

ErrorConfiguration Element

Event Element

File Element

ForeignKeyColumn Element

Group Element

Hierarchy Element

IncrementalProcessingNotification Element

KeyColumn Element

Kpi Element

Level Element

MdxScript Element

Measure Element

MeasureGroup Element

MiningModel Element

MiningModelPermission Element

MiningStructure Element

MiningStructurePermission Element

ModelingFlag Element

NameColumn Element

NamingTemplateTranslation Element

Partition Element

Perspective Element

ProactiveCaching Element

QueryNotification Element

ReportFormatParameter Element

ReportParameter Element

Role Element

ServerProperty Element

SkippedLevelsColumn Element

SourceMeasureGroup Element

TableNotification Element

Trace Element

Translation Element

UnaryOperatorColumn Element

UnknownMemberTranslation Element

ValueColumn Element

Minimize

This topic has not yet been rated - Rate this topic

Level Element (ASSL)

SQL Server 2012

Defines a level in a Hierarchy element.


<Levels>
      <Level>
      <Name>...</Name>
      <ID>...</ID>
      <Description>...</Description>
      <SourceAttributeID>...</SourceAttributeID>
      <HideMemberIf>...</HideMemberIf>
      <Translations>...</Translations>
      <Annotations>...</Annotations>
   </Level>
</Levels>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent element	Levels
Child elements	Annotations, Description, HideMemberIf, ID, Name, SourceAttributeID, Translations

This data type has no restrictions under any deployment mode (1-Multidimensional and Data Mining, 2-SharePoint, and 3-Tabular).

The corresponding element in the Analysis Management Objects (AMO) object model is Level.

Reference

Objects (ASSL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.