Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 230

ment server name. The BIDS sends another request to process the objects
within the database. If you are in the Cube Designer the BIDS assumes that
you want to analyze the data after deployment and processing and therefore
switches the Cube Designer from Cube Structure to Browser, which is dis-
cussed in the next section.
Browsing Cubes
If you deployed a cube to Analysis Services instance the BIDS switches to
the Browser tab. Alternately you can open a cube in the Cube Designer and
click on the Browser tab. In the Browser view you will see three panes: a
Metadata pane, a Filter pane, and a Data pane along with a tool bar as
shown in Figure 6-12 .
Figure 6-12
The Metadata pane, at the left-side pane of the Cube Browser, shows the
measure groups (includes measures) and dimensions (includes attributes and
hierarchies) of the cube. The Data pane, at the bottom right, is the Office Web
Components (OWC) control used for analyzing multidimensional data. You
can drag and drop hierarchies on the rows and/or columns and measures in
the data area to analyze the data. Indeed, you can have multiple hierarchies
on a rows or columns. The OWC has a filter control that can be used to filter
the data being analyzed. You can slice the data you want to analyze based on
specific members of a hierarchy. The top-right pane is also a filter control to