I went digging through the Performance Guide and came about these two
properties I want to change. We have data in two locations and we're hitting
on limitations. I'd like to set the queries to execute on the server rather
than resolve on the server and client box.

My question is...where are they set? Is it just a setting on the client?

You add these settings to the connection string that the client uses,
separating the parameters with semi-colons

eg
;Execution Location=3;Default Isolation Mode=1

You can test these settings in MDX sample by just adding the above
string after the server name in the connection dialog box.

Note that there are some operations which will not run on the server no
matter what you do, so as they say "your mileage may vary"

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <O8LQcoA4FHA.636 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, jesperzz (AT) hotmail (DOT) com
says...