other than excel and BIDS

ive used Sharepoint performance point, not so bad

also SSRS but thats like using BIDS essentially

so if you looking to give users access then i'd go for excel and use powerpivot..

i have only been using and adnimistering SSAS for 9months so pretty new to it myself though