O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by 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 an Analysis Services front-end/tool that allows writing and executing MDX queries.

To connect to data sources like Analysis Services, applications use providers. Relational database environments, on the other hand, allows us to use those providers to ...

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