Export (0) Print
Expand All

Dimension

SQL Server 2000

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.

Show:
© 2014 Microsoft