DimensionAttribute Data Type (ASSL)

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


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

Characteristic

Description

Base data types

None

Derived data types

None

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.

Show: