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)
Properties
Access Element
Account Element (ImpersonationInfo)
AccountType Element
ActionID Element
Administer Element
AggregateFunction Element
AggregationDesignID Element
AggregationFunction Element
AggregationID Element
AggregationInstanceSource Element
AggregationPrefix Element
AggregationStorage Element
AggregationType Element
AggregationUsage Element
Algorithm Element
Alias Element
AllowedRowsExpression Element
AllMemberAggregationUsage Element
AllMemberName Element
AllowBrowsing Element
AllowDrillThrough Element
AllowDuplicateNames Element
AllowedSet Element
Application Element
AssociatedMeasureGroupID Element
AttributeAllMemberName Element
AttributeHierarchyDisplayFolder Element
AttributeHierarchyEnabled Element
AttributeHierarchyOptimizedState Element
AttributeHierarchyOrdered Element
AttributeHierarchyVisible Element
AttributeID Element
Audit Element
AutoRestart Element
BackColor Element
CacheMode Element
CalculationReference Element
CalculationType Element
CalendarEndDate Element
CalendarLanguage Element
CalendarStartDate Element
Caption Element
CaptionIsMdx Element
Cardinality Element
CaseCubeDimensionID Element
ClassifiedColumnID Element
Collation Element
CollectionCaption Element
ColumnID Element (ColumnBinding)
ColumnID Element (EventColumn)
Condition Element
ConnectionString Element
ConnectionStringSecurity Element
Content Element
CreatedTimestamp Element
CubeDimensionID Element
CubeID Element
CurrentStorageMode Element
CurrentTimeMember Element
DataAggregation Element
DatabaseID Element
DataSize Element
DataSourceID Element
DataSourceImpersonationInfo Element
DataSourceViewID Element
DataType Element
DbSchemaName Element
DbTableName Element
Default Element
DefaultMeasure Element
DefaultMember Element
DefaultScript Element
DefaultValue Element
DeniedSet Element
DependsOnDimensionID Element
Description Element
DimensionID Element
DiscretizationBucketCount Element
DiscretizationMethod Element
DisplayFlag Element
DisplayFolder Element
Distribution Element
Edition Element
Enabled Element
EndOfData Element
EstimatedCount Element
EstimatedPerformanceGain Element
EstimatedRows Element
EstimatedSize Element
EventID Element
Expression Element
Filter Element (Binding)
Filter Element (Trace)
FirstDayOfWeek Element
FiscalFirstDayOfMonth Element
FiscalFirstMonth Element
FiscalYearName Element
FoldingParameters Element
FontFlags Element
FontName Element
FontSize Element
ForceRebuildInterval Element
ForeColor Element
Format Element
FormatString Element
Goal Element
GranularityAttributeID Element
HideMemberIf Element
HierarchyID Element
HierarchyUniqueNameStyle Element
HoldoutActualSize Element
HoldoutMaxCases Element
HoldoutMaxPercent Element
HoldoutSeed Element
ID Element
IgnoreUnrelatedDimensions Element
ImpersonationInfo Element
ImpersonationInfoSecurity Element
ImpersonationMode Element
InstanceSelection Element
IntermediateCubeDimensionID Element
IntermediateGranularityAttributeID Element
InvalidXmlCharacters Element
Invocation Element
IsAggregatable Element
IsKey Element
Isolation Element
KeyDuplicate Element
KeyErrorAction Element
KeyErrorLimit Element
KeyErrorLimitAction Element
KeyErrorLogFile Element
KeyNotFound Element
KeyUniquenessGuarantee Element
KpiID Element
Language Element
LastProcessed Element
LastSchemaUpdate Element
LastUpdate Element
Latency Element
LogFileAppend Element
LogFileName Element
LogFileRollover Element
LogFileSize Element
ManagedProvider Element
ManufacturingExtraMonthQuarter Element
ManufacturingFirstMonth Element
ManufacturingFirstWeekOfMonth Element
MasterDatasourceID Element
Materialization Element
MaxActiveConnections Element
MdxMissingMemberMode Element
MeasureExpression Element
MeasureGroupID Element
MeasureID Element
MeasureQualification Element
MemberNamesUnique Element
MemberUniqueNameStyle Element
MembersWithData Element
MembersWithDataCaption Element
MimeType Element
MiningModelID Element
Multiplicity Element
Name Element
NamingTemplate Element
NonEmptyBehavior Element
NotificationTechnique Element
NullKeyConvertedToUnknown Element
NullKeyNotAllowed Element
NullProcessing Element
OnlineMode Element
OptimizedState Element
Optionality Element
OrderBy Element
OrderByAttributeID Element
Ordinal Element
OverrideBehavior Element
PartitionID Element
Password Element
Path Element
PendingValue Element
PermissionSet Element
Persistence Element
Process Element
ProcessingMode Element
ProcessingPriority Element
ProcessingQuery Element
ProductName Element
Query Element
QueryDefinition Element
Read Element
ReadDefinition Element
ReadSourceData Element
RefreshInterval Element
RefreshPolicy Element
RelationshipType Element
RemoteDatasourceID Element
ReportingFirstMonth Element
ReportingFirstWeekOfMonth Element
ReportingWeekToMonthPattern Element
ReportServer Element
RoleID Element
RequiresRestart Element
Root Element
RootMemberIf Element
Schema Element
ScriptCacheProcessingMode Element
SilenceInterval Element
SilenceOverrideInterval Element
Slice Element
SolveOrder Element
Source Element (Binding)
Source Element (ComAssembly)
Source Element (Measure)
SourceAttributeID Element
SourceColumnID Element
State Element
Status Element
StatusGraphic Element
StopTime Element
StorageEngineUsed Element
StorageLocation Element
StorageMode Element
TableID Element
Target Element
TargetType Element
Text Element
Timeout Element
Trend Element
TrendGraphic Element
Trimming Element
Type Element (Action)
Type Element (Binding)
Type Element (ClrAssemblyFile)
Type Element (Dimension)
Type Element (DimensionAttribute)
Type Element (MeasureGroup)
Type Element (MeasureGroupAttribute)
Type Element (MiningStructureColumn)
Type Element (Partition)
Type Element (PerspectiveCalculation)
UnknownMember Element
UnknownMemberName Element
Usage Element (DimensionAttribute)
Usage Element (MiningModelColumn)
Value Element
Version Element
Visibility Element
Visible Element
VisualTotals Element
Write Element
WriteEnabled Element
Expand Minimize
This topic has not yet been rated - Rate this topic

AttributeHierarchyEnabled Element (ASSL)

SQL Server 2012

Determines whether an attribute hierarchy is enabled for the attribute.

Xml
Copy 

<DimensionAttribute><!-- or CubeAttribute -->
   ...
   <AttributeHierarchyEnabled>...</AttributeHierarchyEnabled>
   ...
</DimensionAttribute>

Characteristic

Description

Data type and length

Boolean

Default value

True

Cardinality

0-1: Optional element that can occur once and only once.

Relationship

Element

Parent element

CubeAttribute, DimensionAttribute

Child elements

None

The AttributeHierarchyEnabled element determines whether an attribute hierarchy is generated by Microsoft SQL Server Analysis Services for the attribute. If the attribute hierarchy is not enabled, then the attribute cannot be used in a user-defined hierarchy, nor can the attribute hierarchy be referenced in Multidimensional Expressions (MDX) statements.

The elements that correspond to the parents of AttributeHierarchyEnabled in the Analysis Management Objects (AMO) object model are CubeAttribute and DimensionAttribute.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.