Database Reference
In-Depth Information
Figure 14-7. The results of Exercise 14-1
9.
Run all three queries at once and verify that they return the same results.
Tip: Remember that the word GO is case sensitive! You will receive an error when attempting to run all three
queries at once if GO is not all caps.
in this exercise, you wrote and executed three MDX queries. now let's work on expanding your knowledge of
the MDX language.
Using the Axis 0 and 1 Instead of Column and Row
When writing queries in SQL Server Management Studio, your results are returned using columns and rows.
he words COLUMNS and ROWS are aliases for the position numbers. In MDX, these equate to the positions 0 and 1
 
Search WWH ::




Custom Search