This documentation is archived and is not being maintained.

Axis (MDX)

Updated: 17 July 2006

Returns the set of tuples on a specified axis.


Axis(Axis_Number)

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.

ms145531.note(en-US,SQL.90).gifNote:
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.

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
Show: