Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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.