IgnoreUnrelatedDimensions Element (ASSL)

  • Article

Determines whether unrelated dimensions are forced to their top level when members of dimensions that are unrelated to the measure group are included in a query.

Syntax

<MeasureGroup>
   ...
   <IgnoreUnrelatedDimensions>...</IgnoreUnrelatedDimensions>
   ...
</MeasureGroup>

Element Characteristics

Characteristic Description

Data type and length

Boolean

Default value

True

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent element

MeasureGroup

Child elements

None

Remarks

When IgnoreUnrelatedDimensions is true, unrelated dimensions are forced to their top level; when the value is false, dimensions are not forced to their top level. This property is similar to the Multidimensional Expressions (MDX) ValidMeasure function.

The element that corresponds to the parent of IgnoreUnrelatedDimensions in the Analysis Management Objects (AMO) object model is MeasureGroup.

See Also

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance