I'm reading a little into data warehouses and OLAP DBs and it's a little unclear if I have to learn MDX to be able to query OLAP databases. Secondly, is SSMS the tool used for querying?
SQL Server 2008 R2 (SSAS 2008)
MDX querying in SSAS is done through SSMS. It is not possible to query an Analysis Services instance using TSQL.