O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

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

Executing MDX queries in T-SQL environments

Throughout this book, numerous recipes showed how to create various calculations, either directly in MDX queries or inside the MDX script. Prior to writing and running the queries, you naturally had to establish the connection to your Analysis Services server instance and click on the New Query icon, which opened the SQL Server Management Studio's built-in MDX editor. The other option for running those queries, which we didn't show in this book, was to use the other Analysis Services frontend tool that allows writing and executing MDX queries.

To connect to data sources such as Analysis Services, applications use providers. A relational database environment, on the other hand, allows us to use those providers ...

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