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 PowerPivot 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 PowerPivot 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

Reference

Analysis Services Scripting Language XML Data Types (ASSL)