Database Reference
In-Depth Information
Creating an MDx Query with the Design Mode
At this point, the MDX code in Figure 14-35 does not include any dimension attributes. we are going to
change that by going back to the Design mode and adding in a measure and two dimensional attributes.
1.
Click the Design Mode button again. This changes the cube browser's display back
to design mode.
2.
Drag and drop the Year, Title, and saleQuantity members from the Metadata pane to
the Query pane, as shown in Figure 14-36 .
Figure 14-36. Creating an MDX query using the cube browser's design mode
reviewing the new Code
As you drag and drop measures into the results pane, MDX code is being written for you. it is not necessarily
good MDX code, but it is code you did not have to write yourself. Let's see what the new MDX code
looks like.
1.
Click the Design Mode button to reveal the MDX code the cube browser has
generated (Figure 14-37 ). To make the code easier to see, we've displayed it in
Listing 14-41 as well.
Search WWH ::




Custom Search