Creating Basic MDX Queries

You can create MDX queries to replicate the reports you create by using a browser such as the Office PivotTable list control.

Create a Minimal MDX Query

Start by creating the simplest possible query from the Sales cube.

1.
Replace the contents of the query pane with SELECT FROM Sales. This is the simplest possible MDX query. You can now run this query.
2.
Click the Run Query button on the toolbar. (If you don’t see the results pane, click the Split View button to the right of the Run Query button; the Split View button displays the results pane below the metadata pane.) A single number appears in the report. The number in the report—35,696.00—is the total Sales Dollars for the entire cube. Because the query does ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

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