Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

DimensionAttribute Data Type (ASSL)

 

Applies To: SQL Server 2016 Preview

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

Community Additions

ADD
Show:
© 2015 Microsoft