IgnoreUnrelatedDimensions Element (ASSL)


Applies To: SQL Server 2016 Preview

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.


Data type and lengthBoolean
Default valueTrue
Cardinality0-1: Optional element that can occur once and only once.
Parent elementMeasureGroup
Child elementsNone

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.

Properties (ASSL)

Community Additions