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