Search code examples
sql-serverssas

Can I use TSQL to query an OLAP database or is MDX required?


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)


Solution

  • MDX querying in SSAS is done through SSMS. It is not possible to query an Analysis Services instance using TSQL.