O'Reilly logo

Instant MDX Queries for SQL Server 2012 by Nicholas Emond

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

Quick start – writing your first MDX query

A MDX query is code and executed against a cube to have a result in a specific format return to the client application.

Step 1 – open the SQL Server Management Studio and connect to the cube

The Microsoft SQL Server Management Studio (SSMS) is a client application used by the administrators to manage instances and by developers to create object and write queries. We will use SSMS to connect on the cube and write our first MDX query. Here's a screenshot of SSMS with a connection on a SSAS server:

Step 1 – open the SQL Server Management Studio and connect to the cube
  1. Click on the Windows button, click on All Programs, click on Microsoft SQL Server 2012, and then click on SQL Server ...

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