What PB_BI said.
It's also worth noting that you can access SSAS via BIDS or SSDT (depending on the version of SSAS you ate running).
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001