Chapter 3. Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)

SQL Server Analysis Services (SSAS) multidimensional and tabular models rely on separate expression languages for both modeling and querying purposes. You use the Multidimensional Expressions (MDX) language to incorporate business logic into a cube for reusability as calculations and to return query results from a cube. Cube queries can be ad hoc, embedded into a reporting application, or generated automatically by client tools such as Excel. Likewise, you use the Data Analysis Expressions (DAX) language to enhance a tabular model not only by adding business logic, but also to perform data transformation tasks such as concatenating or splitting ...

Get Exam Ref 70-768 Developing SQL Data Models, First Edition now with the O’Reilly learning platform.

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