Microsoft Office Tutorials and References
In Depth Information
Using the MDX editor is pretty simple and looks much like using the PivotTable. To build the
query, it is enough to drag measures, dimension attributes, or complete hierarchies from the
selector in the query area. The wizard immediately refreshes the query, showing you a preview
of the data set you are about to query.
The editor is very similar to an Excel PivotTable. The only noticeable difference is that you
cannot put data items in columns; you can retrieve items only in rows. You can better
understand it if you compare Figure 5-18 with Figure 5-20, in which you can see the same query
using Excel. We put the calendar year, as you are probably used to seeing it, in columns.
FIguRE 5-20 We are accustomed to using columns for dates or other dimensions in Excel reporting.
If you put the calendar year in PivotTable rows instead of columns, (see Figure 5-21), you get
a result identical to that produced by the query editor.
FIguRE 5-21 If you put dimensions only in rows, you get the same result from the wizard and from Excel.
You can see that, from the point of view of the data, there is no difference at all between the
two representations; it is just a matter of pivoting information.