You will need to fix the error through Visual Studio (BIDS). Can you please post the error message and what you determined to be the problem with the SQL statement?
The Microsoft offerings are ProClarity, PerformancePoint Server, and Excel 2007. ProClarity and PerformancePoint server are very powerful reporting tools. There are many OLAP cube viewers out there but you need...