Browse Pane

The Calculated Member Manager includes the Browse pane, which organizes the virtual cube data in the data grid. The default view for the data grid shows the data in table format with one dimension across the column headings and another dimension down the left column. (Measures are treated as a single dimension for this purpose.) The remaining dimensions of the virtual cube are displayed in the slicer pane.

The following example Browse pane shows the sample Warehouse and Sales virtual cube included with Microsoft® SQL Server™ OLAP Services.

The white data grid cells represent the measure values according to the members that appear in the levels boxes for all the dimensions shown in the slicer pane. In the preceding example, the measure values reflect the All (that is, highest level) members of all dimensions in the slicer pane except Time. The levels box for the Time dimension displays 1997, which indicates that the displayed measure values are limited to 1997. Later in this topic, an example shows you how to slice through dimensions in the slicer pane to limit the measure values that are displayed.

Working in the Browse Pane

To browse the virtual cube data in the data grid by any combination of dimensions, drag measures or dimensions from the slicer pane onto either axis on the data grid.

To replace a dimension on the data grid with another dimension

Drag the dimension from the slicer pane to the dimension in the data grid that you want to replace.

The pointer is in the correct position when it appears like this:

-Or-

The dimension in the data grid moves up to the slicer pane and the new one takes its place.

To move a dimension to the data grid

Drag the dimension from the slicer pane to a cell below (or beside) the existing dimension.

The pointer is in the correct position when it appears like this:

-Or-

The new dimension appears under (or beside) the existing dimension, expanding your data grid.

To change the order of dimensions on the data grid

Drag the dimension and drop it on the dimension where you want it to be located.

To remove a dimension from the data grid

Drag the dimension you want to remove from the data grid to the slicer pane.

To drill down into a member

Double-click a dimension member on the data grid. If the member has members beneath it, they are displayed.

Only the member you double-click is expanded. The other members retain their current levels in the data grid. For example, in the following Browse pane, double-click the Food member to drill down into its child members.

If you want to display all the members in a level, double-click the parent level name in the data grid. Level names are depicted with the shading of a button.

To slice through a dimension

To change the member in a dimension in the slicer pane, click the down arrow on the levels box, expand the levels, and then select a new member. The virtual cube data in the data grid changes to reflect the change in the dimension member.

The Browse pane has an internal memory limit which you may reach if you attempt to browse too much data or drill down too deeply. When you reach the limit, the following message is displayed:

Unable to display current view of cube.
Unable to Allocate Memory For Flexgrid.

The limit cannot be increased by adding or allocating more memory. If you reach the limit, reduce the amount or depth of data you are attempting to browse or use another browser.

(c) 1999 Microsoft Corporation. All Rights Reserved.