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

Axis (MDX)

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. This function can be used to make calculated members aware of the context of the query that is being run. For example, you might need a calculated member that provides the sum of only those members selected on the Rows axis. It can also be used to make the definition of one axis dependent on the definition of another. For example, by ordering the contents of the Rows axis according to the value of the first item on the Columns axis.

Note 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.

The following example query shows how to use the Axis function:

WITH MEMBER MEASURES.AXISDEMO AS

SETTOSTR(AXIS(1))

SELECT MEASURES.AXISDEMO ON 0,

[Date].[Calendar Year].MEMBERS ON 1

FROM [Adventure Works]

The following example shows the use of the Axis function inside a calculated member:

WITH MEMBER MEASURES.AXISDEMO AS

SUM(AXIS(1), [Measures].[Internet Sales Amount])

SELECT {[Measures].[Internet Sales Amount],MEASURES.AXISDEMO} ON 0,

{[Date].[Calendar Year].&[2003], [Date].[Calendar Year].&[2004]} ON 1

FROM [Adventure Works]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft