you can use xtrapivotGrid in devexpress windows forms components package for ad hoc query on SSAS cube.

devexpress had other control for ad hoc query in web applications and silverlight.