Hi experts!
I would like to known - is it possible to enable server-side calculation
for the calculated members 2005. Because in AS 2000 we can use Execution
Location property in *.oqy file. But is it possible to tell sql server AS to
make a calculation on server side.

Thank in advance.

Ramunas Balukonis

Ramunas, as far as I understand, all calculations are done server side
in 2005.

yes,
I have read an article which says that the calculations results are cached
on the server to improve the performance.

but you have to comfirm this.


"KoryS" <kskistad (AT) hotmail (DOT) com> wrote

Confirmed. All calculations are done on the server.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =