Chapter 6. Querying Tabular

As you have seen, a Tabular Business Intelligence Semantic Model (BISM) can be queried by using both MDX and DAX languages. These two languages use different abstraction concepts to represent the underlying data model and have different syntaxes. A client tool might generate queries in one of these languages. For example, a Microsoft Excel PivotTable generates queries in MDX, whereas Power View generates queries in DAX. If you are writing your own report, for example by using Reporting Services, you can choose between both languages.

A query written in DAX manipulates tables and returns a table. If you have a BISM Tabular model, you might prefer using DAX because DAX natively returns a table, whereas MDX natively returns ...

Get Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.