ReferenceMeasureGroupDimension Data Type (ASSL)

Defines a derived data type that represents a dimension that is indirectly related to the fact table through an intermediate dimension. (For example, a Sales measure group can reference a Geography dimension, which is related through the Customer dimension.)

Syntax

<ReferenceMeasureGroupDimension>
   <!-- The following elements extend MeasureGroupDimension -->
      <IntermediateCubeDimensionID>...</IntermediateCubeDimensionID>
   <IntermediateGranularityAttributeID>...</IntermediateGranularityAttributeID>
   <Materialization>...</Materialization>
</ReferenceMeasureGroupDimension>

Data Type Characteristics

Characteristic	Description
Base data types	MeasureGroupDimension
Derived data types	None

Data Type Relationships

Relationship	Element
Parent elements	None
Child elements	IntermediateCubeDimensionID, IntermediateGranularityAttributeID, Materialization
Derived elements	None

Remarks

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

See Also

Reference

Analysis Services Scripting Language XML Data Types (ASSL)

Help and Information

Getting SQL Server 2005 Assistance