MakeAxis()
Use MakeAxis() to build an axis expression string for use in MDX.
If you want to use axes in your MDX, you can use MakeAxis() to build an expression that can be used in MDX. MakeAxis() takes an input of strings and assembles the output as an axis expression.
Syntax
MakeAxis(<dimension properties>, <set>, <axis ID>, <axis properties>)|
Argument |
Description |
Required/Optional |
|---|---|---|
|
Dimension properties |
The dimension properties that you want to use when building the axis expression string. |
Required |
| Set |
The set that you want to use when building the axis expression string. |
Required |
| Axis ID |
The axis ID for the axis that you want to use when building the axis expression string. |
Required |
| Axis properties |
The axis properties that you want to use when building the axis expression string. If used, the output will not include the dimension properties. |
Optional |