SQL Server
United States (English) Sign in
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)
ASSL Reference
Analysis Services Scripting Language XML Elements (ASSL)
Objects
Account Element
Action 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
Column 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
Member 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
Server Element
ServerProperty Element
SkippedLevelsColumn Element
SourceMeasureGroup Element
TableNotification Element
Trace Element
Translation Element
UnaryOperatorColumn Element
UnknownMemberTranslation Element
ValueColumn Element
Expand Minimize
This topic has not yet been rated - Rate this topic

Hierarchy Element (ASSL)

SQL Server 2012

Defines a hierarchy in a dimension.

Xml
Copy 

<Hierarchies>
   <Hierarchy xsi:type="Hierarchy">...</Hierarchy> <!-- ancestor: Dimension -->
   <!-- or -->
   <Hierarchy xsi:type="CubeHierarchy">...</Hierarchy> <!-- ancestor: CubeDimension -->
   <!-- or -->
   <Hierarchy xsi:type="PerspectiveHierarchy">...</Hierarchy> <!-- ancestor: PerspectiveDimension -->
   <!-- or -->
   <Hierarchy xsi:type="MeasureGroupHierarchy">...</Hierarchy> <!-- ancestor: RegularMeasureGroupDimension -->
</Hierarchies>

Characteristic

Description

Data type and length

Ancestor or Parent

Data Type

Dimension

Hierarchy

CubeDimension

CubeHierarchy

PerspectiveDimension

PerspectiveHierarchy

RegularMeasureGroupDimension

MeasureGroupHierarchy

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Relationship

Element

Parent elements

Hierarchies

Child elements

None

The corresponding elements in the Analysis Management Objects (AMO) object model are Hierarchy, CubeHierarchy, and PerspectiveHierarchy.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.