Running Queries
In Chapter 17, we’ll cover how to write .NET code to query your cube in your own applications. For now, we’ll just use the Browser tab within the cube designer to run some quick queries. Click the Browser tab now—it’s the last one. This cube browser is really just an administrative tool and limited to result sets with two axes. It is similar in functionality to the Office Excel PivotTable tool and actually uses the PivotTable control from version 11 of Office Web Components.
Once the browser loads, drill down on the Measures node and then on the Main measure group node in the tree view on the upper left. Drag the Total Sales measure into the Drop Totals Or Detail Fields Here area of the output region. Next, drag the Year attribute ...
Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
