Firstly why would you not want to design OLAP cubes using Visual Studio (or Business Intelligence Studio), it's the native tool for creating cubes?!
Querying from the cubes can be done from a number of 3rd party solutions, Business Objects etc etc.
Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified