Edit

Share via

DimensionAttribute Data Type (ASSL)

  • Article

Defines a primitive data type that represents an attribute in a dimension.

Syntax

  
<DimensionAttribute>  
   <Name>...</Name>  
   <ID>...</ID>  
   <Description>...</Description>  
   <Type>...</Type>  
   <Usage>...</Usage>  
   <Source>...</Source>  
   <EstimatedCount>...</EstimatedCount>  
   <KeyColumns>...</KeyColumns>  
   <NameColumn>...</NameColumn>  
   <ValueColumn>...</ValueColumn>  
   <Translations>...</Translations>  
   <AttributeRelationships>...</AttributeRelationships>  
   <DiscretizationMethod>...</DiscretizationMethod>  
   <DiscretizationBucketCount>...</DiscretizationBucketCount>  
   <RootMemberIf>...</RootMemberIf>  
   <OrderBy>...</OrderBy>  
   <DefaultMember>...</DefaultMember>  
   <OrderByAttributeID>...</OrderByAttributeID>  
   <SkippedLevelsColumn>...</SkippedLevelsColumn>  
   <NamingTemplate>...</NamingTemplate>  
   <MembersWithData>...</MembersWithData>  
   <MembersWithDataCaption>...</MembersWithDataCaption>  
   <NamingTemplateTranslations>...</NamingTemplateTranslations>  
   <CustomRollupColumn>...</CustomRollupColumn>  
   <CustomRollupPropertiesColumn>...</CustomRollupPropertiesColumn>  
   <UnaryOperatorColumn>...</UnaryOperatorColumn>  
   <AttributeHierarchyOrdered>...</AttributeHierarchyOrdered>  
   <MemberNamesUnique>...</MemberNamesUnique>  
   <IsAggregatable>...</IsAggregatable>  
   <AttributeHierarchyEnabled>...</AttributeHierarchyEnabled>  
   <AttributeHierarchyOptimizedState>...</AttributeHierarchyOptimizedState>  
   <AttributeHierarchyVisible>...</AttributeHierarchyVisible>  
   <AttributeHierarchyDisplayFolder>...</AttributeHierarchyDisplayFolder>  
   <KeyUniquenessGuarantee>...<KeyUniquenessGuarantee>  
   <InstanceSelection>...</InstanceSelection>  
   <Annotations>...</Annotations>  
</DimensionAttribute>

Data Type Characteristics

Characteristic Description
Base data types None
Derived data types None

Data Type Relationships

Relationship Element
Parent elements None
Child elements Annotations, AttributeHierarchyDisplayFolder, AttributeHierarchyEnabled, AttributeHierarchyOptimizedState, AttributeHierarchyOrdered, AttributeHierarchyVisible, AttributeRelationships, CustomRollupColumn, CustomRollupPropertiesColumn, DefaultMember, Description, DiscretizationBucketCount, DiscretizationMethod, EstimatedCount, ID, InstanceSelection, IsAggregatable, KeyColumns, KeyUniquenessGuarantee, MemberNamesUnique, MembersWithData, MembersWithDataCaption, Name, NameColumn, NamingTemplate, NamingTemplateTranslations, OrderBy, OrderByAttributeID, RootMemberIf, SkippedLevelsColumn, Source, Translations, Type, UnaryOperatorColumn, Usage, ValueColumn
Derived elements Attribute (Attributes collection of Dimension)

Remarks

The following restrictions apply when running the service in DeploymentMode configuration property values of 1 and 2 (SharePoint and Tabular modes, used to run Power Pivot and tabular model databases):

  • Usage element only accepts KEY or REGULAR values.

  • IsAggregatable element cannot be false.

  • OrderBy element only accepts KEY or PROPERTYKEY values.

  • A calculated column cannot be a primary key in the table.

  • A calculated column cannot contain DataSize in the binding.

  • For each calculated column a syntax validation is performed before saving the attribute definition.

  • For AttributeRelationships, RelationshipType must be set to the value, Flexible.

  • The attribute ‘RowNumber’, identified by ‘RowNumber’, must have the type integer.

  • Only the attribute ‘RowNumber’ can have KeyBinding of type RowNumberBinding.

  • All attributes other than ‘RowNumber’ must have a Cardinality of one in relation to the key, unless the attribute itself is the key.

  • When the column specified by OrderBy is also the PropertyKey, the OrderByAttributeId cannot point to the row number column.

  • Attributes used as keys should be related to all other attributes; other types of relationships are not supported.

  • The NullProcessing element cannot be set to ‘UnknownMember’.

  • Bindings cannot be set to ‘Value’.

The following elements are unsupported when running the service in DeploymentMode configuration property values of 1 and 2 (SharePoint and Tabular modes, used to run Power Pivot and tabular model databases):

  • AttributeHierarchyOptimizedState

  • CustomRollupColumn

  • CustomRollupPropertiesColumn

  • DefaultMember

  • DiscretizationBucketCount

  • DiscretizationMethod

  • SkippedLevelsColumn

  • Source

  • UnaryOperatorColumn

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

See Also

Analysis Services Scripting Language XML Data Types (ASSL)