Analysis Services
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.