O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Writing Your First MDX Queries

We’ll begin by entering queries directly into the query editor window in SSMS. To do this, start SSMS, and connect to your SQL Server Analysis Services (SSAS) instance and Adventure Works DW sample. Next, select the OLAP cube from the SSMS Object Explorer, and then click the New Query button to open a new MDX query editor window. The principal use of new queries is twofold: to generate particular types of reports or as the result of directly manipulating cube data in a client interface, such as a pivot table that supports direct query generation. A basic MDX query contains a SELECT statement, a definition for the COLUMNS axis, a definition for the ROWS axis, and the source cube. So a simple but meaningful query we ...

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