Database Reference
In-Depth Information
Figure 11-12.
he Browser tab
reFreShING the BrOWSer
To use the browser tab, the dimensions must have already been uploaded to your Analysis Server and the
cube processed. it does not work if the XML files have been generated only in Visual Studio. After processing
the cube, you need to manually reconnect to SSAS to see the latest version. Do so by clicking the Reconnect
button on the browser's toolbar to refresh the browser (circled in Figure
11-12
). oddly, you do not use the
Refresh button as you might expect! Throughout this chapter, we make several changes and reprocess the
cube. This means you click the Reconnect button a number of times.
When the Browser tab is open, its treeview is visible on the left side of the screen. Measures and dimensions
can be dragged from this treeview to the center for viewing. The interface is very similar to working with a pivot
table in Excel, but most developers find it to be rather unintuitive.
Begin by selecting an item from the treeview. It is best to start with a measure, such as the Sales Quantity
measure shown in Figure
11-12
. Drag and drop the measure to the middle of the viewing pane where it says
“Drag levels or measures here to add to the query.” The query referred to here is the MDX query that will be
invisibly written for you by Visual Studio.
Once you have dragged and dropped your measure into the viewing pane, the grand total of the measured
value will be displayed. To see a breakdown of this grand total based on a dimensional attribute, you need to drag
