Axis (MDX)

  • Article

Returns the set of tuples on a specified axis.

Syntax

Axis(Axis_Number)

Arguments

  • Axis_Number
    A valid numeric expression that specifies the axis number.

Remarks

The Axis function uses the zero-based position of an axis to return the set of tuples on an axis. For example, Axis(0) returns the COLUMNS axis, Axis(1) returns the ROWS axis, and so on. The Axis function cannot be used on the filter axis.

Note

An axis can reference only a prior axis. For example, Axis(0) must occur after the COLUMNS axis has been evaluated, such as on a ROW or PAGE axis.

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006
Changed content:
  • Updated syntax and arguments to improve clarity.