Dimension

Returns the dimension that contains a specified member, level, or hierarchy.

Syntax

Member

«Member».Dimension

Returns the dimension that contains «Member».

Level

«Level».Dimension

Returns the dimension that contains «Level».

Hierarchy

«Hierarchy».Dimension

Returns the dimension that contains «Hierarchy».

Remarks

Microsoft® SQL Server™ 2000 Analysis Services implements hierarchies as separate dimensions, so «Hierarchy».Dimension returns «Hierarchy».

Example

Member

[1998].Dimension 

This example returns Time.

Level

Year.Dimension

This example returns Time.

Hierarchy

FiscalYear.Dimension

This example returns Time.