Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

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.

Community Additions

ADD
Show:
© 2014 Microsoft