Database Reference
In-Depth Information
one of the biggest differences between a sQL code window and an MDX code window is that the
MDX version allows you to execute only one query per batch! if you try to run more than one statement at a time,
you will receive a syntax error. You can, however, separate multiple statements into their own batches using the word
GO . And by the way, GO is case sensitive in the MDX editor. we show you an example in the next exercise!
Important
We have covered quite a few of the basics. It's time to try some MDX code on your own. This next exercise
will get you started.
exerCise 14-1. exeCuting MDx Queries
in this exercise, you create a new MDX query similar to the one we just walked though. You also write
another query that returns the sales quantity for the store called BookBeat. Your final results should look
similar to Figure 14-7 .
1. open sQL server Management studio. You can do so by clicking the start button and
selecting All Programs ➤ Microsoft sQL server 2012 ➤ sQL server Management
studio.
Important: Remember to right-click the menu item, select Run as Administrator, and then answer Yes to
close the uAC.
2.
when sQL server Management studio opens, it will display a dialog window similar
to the one in Figure 14-5 .
3.
select Analysis server from the “server type” drop-down box.
4.
Type the name of your server in the “server name” textbox.
Tip: This will usually be (local) unless you use a named instance of sQL server, as shown in Figure 14-5 .
Figure 14-5. The connection to Analysis Server
 
 
Search WWH ::




Custom Search