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 2008

Product Documentation

SQL Server 2008 Books Online

Analysis Services - Multidimensional Data

Technical Reference

Analysis Services Scripting Language Reference

Analysis Services Scripting Language XML Elements (ASSL)

Account Element (ASSL)

Action Element (ASSL)

Aggregation Element (ASSL)

AggregationDesign Element (ASSL)

AggregationInstance Element (ASSL)

AlgorithmParameter Element (ASSL)

AllMemberTranslation Element (ASSL)

Annotation Element (ASSL)

Assembly Element (ASSL)

Attribute Element (ASSL)

AttributeAllMemberTranslation Element (ASSL)

AttributePermission Element (ASSL)

AttributeRelationship Element (ASSL)

Block Element (ASSL)

Calculation Element (ASSL)

CalculationProperty Element (ASSL)

CaptionColumn Element (ASSL)

CellPermission Element (ASSL)

Column Element (ASSL)

Command Element (ASSL)

Cube Element (ASSL)

CubePermission Element (ASSL)

CustomRollupColumn Element (ASSL)

CustomRollupPropertiesColumn Element (ASSL)

Data Element (ASSL)

Database Element (ASSL)

DatabasePermission Element (ASSL)

DataSource Element (ASSL)

DataSourcePermission Element (ASSL)

DataSourceView Element (ASSL)

Dimension Element (ASSL)

DimensionPermission Element (ASSL)

ErrorConfiguration Element (ASSL)

Event Element (ASSL)

File Element (ASSL)

ForeignKeyColumn Element (ASSL)

Group Element (ASSL)

Hierarchy Element (ASSL)

IncrementalProcessingNotification Element (ASSL)

KeyColumn Element (ASSL)

Kpi Element (ASSL)

Level Element (ASSL)

MdxScript Element (ASSL)

Measure Element (ASSL)

MeasureGroup Element (ASSL)

Member Element (ASSL)

MiningModel Element (ASSL)

MiningModelPermission Element (ASSL)

MiningStructure Element (ASSL)

MiningStructurePermission Element (ASSL)

ModelingFlag Element (ASSL)

NameColumn Element (ASSL)

NamingTemplateTranslation Element (ASSL)

Partition Element (ASSL)

Perspective Element (ASSL)

ProactiveCaching Element (ASSL)

QueryNotification Element (ASSL)

ReportFormatParameter Element (ASSL)

ReportParameter Element (ASSL)

Role Element (ASSL)

Server Element (ASSL)

ServerProperty Element (ASSL)

SkippedLevelsColumn Element (ASSL)

SourceMeasureGroup Element (ASSL)

TableNotification Element (ASSL)

Trace Element (ASSL)

Translation Element (ASSL)

UnaryOperatorColumn Element (ASSL)

UnknownMemberTranslation Element (ASSL)

ValueColumn Element (ASSL)

Minimize

This topic has not yet been rated - Rate this topic

Dimension Element (ASSL)

SQL Server 2008

Defines a dimension.


<Dimensions>
   <Dimension xsi:type="Dimension">...</Dimension> <!-- ancestor: Database -->
   <!-- or -->
   <Dimension xsi:type="AggregationDimension">...</Dimension> <!-- ancestor: Aggregation -->
   <!-- or -->
   <Dimension xsi:type="AggregationDesignDimension">...</Dimension> <!-- ancestor: AggregationDesign -->
   <!-- or -->
   <Dimension xsi:type="AggregationInstanceCubeDimension">...</Dimension> <!-- ancestor: AggregationInstance -->
      <!-- or -->
   <Dimension xsi:type="CubeDimension">...</Dimension> <!-- ancestor: Cube -->
      <!-- or -->
   <Dimension xsi:type="MeasureGroupDimension">...</Dimension> <!-- ancestor: MeasureGroup -->
   <!-- or -->
   <Dimension xsi:type="PerspectiveDimension">...</Dimension> <!-- ancestor: Perspective -->
</Dimensions>

Element Characteristics

Characteristic	Description
Data type and length	Ancestor or ParentData Type DatabaseDimension AggregationAggregationDimension AggregationDesignAggregationDesignDimension AggregationInstanceAggregationInstanceCubeDimension CubeCubeDimension MeasureGroupMeasureGroupDimension PerspectivePerspectiveDimension
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	Dimensions
Child elements	None

The corresponding elements in the Analysis Management Objects (AMO) object model are Dimension, AggregationDimension, AggregationDesignDimension, CubeDimension, MeasureGroupDimension, and PerspectiveDimension.

Reference

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.