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.
Replace the contents of the query pane with SELECT FROM Sales. This is the simplest possible MDX query. You can now run this query.
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 ...