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 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Programming Reference

Analysis Services Administration Programming

Analysis Services Scripting Language (ASSL)

Analysis Services Scripting Language Reference

Analysis Services Scripting Language XML Elements

Collections

Accounts Element

Actions Element

AggregationDesigns Element

AggregationInstances Element

Aggregations Element

AlgorithmParameters Element

Aliases Element

AllMemberTranslations Element

Annotations Element

Assemblies Element

AttributeAllMemberTranslations Element

AttributePermissions Element

AttributeRelationships Element

Attributes Element

CalculationProperties Element

Calculations Element

CellPermissions Element

ClassifiedColumns Element

Columns Element

Commands Element

CubePermissions Element

Cubes Element

DatabasePermissions Element

Databases Element

DataSources Element

DataSourcePermissions Element

DataSourceViews Element

DimensionPermissions Element

Dimensions Element

Files Element

ForeignKeyColumns Element

Hierarchies Element

IncrementalProcessingNotifications Element

KeyColumns Element

Kpis Element

MdxScripts Element

MeasureGroups Element

Measures Element

Members Element

MiningModelPermissions Element

MiningModels Element

MiningStructurePermissions Element

MiningStructures Element

ModelingFlags Element

NamingTemplateTranslations Element

Partitions Element

Perspectives Element

QueryNotifications Element

ReportFormatParameters Element

ReportParameters Element

Roles Element

ServerProperties Element

TableNotifications Element

Translations Element

UnknownMemberTranslations Element

Minimize

This topic has not yet been rated - Rate this topic

Dimensions Element (ASSL)

SQL Server 2005

SQL Server 2012

Contains the collection of dimensions associated with the parent element.


<Database> <!-- or Aggregation, AggregationDesign, AggregationInstance, Cube, MeasureGroup, Perspective -->
   ...
   <Dimensions>
      <Dimension>...</Dimension>
   </Dimensions>
   ...
</Database>

Element Characteristics

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

Element Relationships

Relationship	Element
Parent elements	Aggregation, AggregationDesign, AggregationInstance, Cube, Database, MeasureGroup, Perspective
Child elements	Dimension

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

Reference

Collections (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

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.