Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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
Axis(0)
The set of members represented by {Time.Members}, in the COLUMNS axis.
Axis(1)
The set of members represented by {Location.Members}, in the ROWS axis.