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

CubeAttribute Data Type (ASSL)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Defines a primitive data type that represents an attribute associated with a Cube element.

<CubeAttribute>
   <AttributeID>...</AttributeID>
   <AggregationUsage>...</AggregationUsage>
   <AttributeHierarchyOptimizedState>...</AttributeHierarchyOptimizedState>
   <AttributeHierarchyEnabled>...</AttributeHierarchyEnabled>
   <AttributeHierarchyVisible>...</AttributeHierarchyVisible>
   <Annotations>...</Annotations>
</CubeAttribute>

Characteristic

Description

Base data types

None

Derived data types

None

The AttributeHierarchyOptimizedState element is not supported when running the service in DeploymentMode configuration property values of 1 or 2 (SharePoint or Tabular modes, used to run Power Pivot and tabular model databases).

An attribute cannot be added as a level of a hierarchy when the property, AtttributeHierarchyEnabled, is set to FALSE and the instance is operating under DeploymentMode 1 or 2 (SharePoint or Tabular server mode).

Attributes in the CubeDimension element that are not explicitly included in the Attributes collection become part of the collection with default values assigned to them. After attributes are added to the collection, the attributes can be returned by the Discover method.

The AggregationUsage element controls how Microsoft SQL Server Analysis Services automatically designs aggregations for the attribute. The AggregationUsage element does not constrain any aggregations that are manually created for the cube.

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

Community Additions

ADD
Show:
© 2015 Microsoft