We are running MDX queries using ADO MD. Whenever new connection is opened and access the cube, it retrives the whole cube data to client side instead of query results only. This is causing performance bottleneck in terms of network traffic.

Can we set up anything on Analysis Server to send only query results to client side instead of sending whole cube data.