CubeDimension Data Type (ASSL)

  • Article

Defines a primitive data type that represents the relationship between a dimension and a cube.

Syntax

<CubeDimension>
      <ID>...</ID>
   <Name>...</Name>
   <Translations>...</Translations>
   <DimensionID>...</DimensionID>
   <Visible>...</Visible>
   <AllMemberAggregationUsage>...</AllMemberAggregationUsage>
   <HierarchyUniqueNameStyle>...</HierarchyUniqueNameStyle>
   <MemberUniqueNameStyle>...</MemberUniqueNameStyle>
      <Attributes>...</Attributes>
   <Hierarchies>...</Hierarchies>
      <Annotations>...</Annotation>
</CubeDimension>

Data Type Characteristics

Characteristic Description

Base data types

None

Derived data types

None

Data Type Relationships

Relationship Element

Parent elements

None

Child elements

AllMemberAggregationUsage, Annotations, Attributes, DimensionID, Hierarchies, HierarchyUniqueNameStyle, ID, MemberUniqueNameStyle, Name, Visible, Translations

Derived elements

Dimension (Dimensions collection of Cube)

Remarks

There is one CubeDimension for each dimension relationship on a Cube. The CubeDimension covers all the MeasureGroups of the cube.

A CubeDimension must include a CubeHierarchy if the dimension has something specific to say about the hierarchy, including disabling the hierarchy (thereby, allowing selection of which hierarchies apply to a particular dimension usage), or making the hierarchy invisible.

Similarly, a CubeDimension must include a CubeAttribute only if the dimension has something specific to say about the attribute. (There is no way to select which attributes apply to a particular dimension usage, though attributes can be made invisible).

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

See Also

Reference

Analysis Services Scripting Language XML Data Types (ASSL)

Help and Information

Getting SQL Server 2005 Assistance