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

CubeDimension Data Type (ASSL)

 

Applies To: SQL Server 2016 Preview

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


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

Characteristic

Description

Base data types

None

Derived data types

None

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.

Community Additions

ADD
Show:
© 2015 Microsoft