The number of axes and the contents of each axis are specified after the SELECT keyword and immediately before the FROM clause in the syntax shown in Parts of an MDX Query.
Each <axis_specification> value specifies one axis. The number of axes in the dataset is equal to the number of <axis_specification> values in the MDX query.
The breakdown of the <axis_specification> syntax is:
<axis_specification> ::= <set> ON <axis_name>
Each <set> value defines the contents of an axis. The following topics describe the <set> and <axis_name> values in more detail.