Axis (MDX)

Returns the set of tuples on a specified axis.




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


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.


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


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.