Analysis Services
Axis
Returns a set defined in an axis.
Syntax
Axis(«Numeric Expression»)
Remarks
The Axis function uses the zero-based position of an axis, specified in «Numeric Expression», to return the set defined in the axis. For example, Axis(0) returns the COLUMNS axis, Axis(1) returns the ROWS axis, and so on. This function cannot be used on the filter axis.
Example
The examples in the table use the following Multidimensional Expressions (MDX) query.
SELECT {Time.Members} ON COLUMNS, {Location.Members} ON ROWS
FROM TestCube
| Expression | Returns |
|---|---|
|
The set of members represented by {Time.Members}, in the COLUMNS axis. |
|
The set of members represented by {Location.Members}, in the ROWS axis. |