O'Reilly logo

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model by Alberto Ferrari Marco Russo and Chris Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required