O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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

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 ...

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