Dimension

The MDX Dimension function returns the Essbase dimension that contains the input element. Use it when you need to pass a dimension to another function, but you are unsure of the dimension to which a particular member, generation, or level belongs.

Syntax

member.Dimension

layer.Dimension

Dimension ( member | layer )

Parameters

member

A member specification. The dimension returned is the dimension that this member belongs to.

layer

A layer specification. The dimension returned is the dimension that this layer belongs to.

Example

The following examples are for Sample.Basic:

[Colas].Dimension returns Product.

[Market].[Region].Dimension returns Market.

The following example is for ASOSamp.Basic. [80101].Dimension) returns Geography dimension. A dimension is expected by the CurrentMember function.

(CurrentMember([80101].Dimension),[Curr Year])