Querying a Tabular Model
Two query languages are used with the Tabular implementation of SSAS Tabular. Any client tool that generates MDX can connect to and browse a model because Tabular exposes the same interface and metadata as a multidimensional SSAS database. This is how Excel currently interfaces with a Tabular Model from a PivotTable or PivotChart.
With handwritten queries, you also have the option to use the DAX query syntax. In this section, I'll give you a brief tour of the fundamental constructs of a DAX query and the most essential commands used to get results and navigate a model.
Getting ready
In the Deploying Tabular Models recipe in Chapter 9, Using Tabular Models, using Data tools, the deployment wizard, and the deployment utility, you configured the SSDT project to create a database named SSAS Cookbook Chapter 9.
To start with this recipe, please follow the given steps:
- Follow the instructions in that recipe to return to the Project Property Pages dialog and change the...
