Export (0) Print
Expand All
Expand Minimize

Cube Browser

SQL Server 2000

Cube Browser

Use this tool to view data in a cube.

Cube Browser organizes the cube data in the data viewing pane. The default view in the data viewing pane 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 cube are displayed in the data slicing pane.

Cube Browser

The white cells in the data viewing pane represent the measure values according to the members that appear in the members boxes for all the dimensions shown in the data slicing pane. In the preceding example, the measure values reflect the All member of every dimension in the data slicing pane except Time. The members 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 data slicing pane to limit the measure values that are displayed.

Cube Browser is displayed when you perform one of the following actions:

  • In the Analysis Manager tree pane, right-click a processed cube, and then click Browse Data. If the structure of a cube has changed since it was last processed, the cube must be processed before you perform this action. Also, you can view sample data in the Data tab of Cube Editor.

  • In the last step of the Cube Wizard, click Browse Sample Data. The displayed data is sample data rather than actual data because the cube has not yet been processed.
Working in Cube Browser

To browse the cube data in the data viewing pane by any combination of dimensions, drag measures or dimensions from the data slicing pane onto either axis in the data viewing pane.

To replace a dimension in the data viewing pane with another dimension

  • Drag the dimension from the data slicing pane to the dimension in the data viewing pane that you want to replace.
Replacing a Dimension

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

-or-

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

To move a dimension to the data viewing pane

  • Drag the dimension from the data slicing pane to a cell below (or beside) the existing dimension.
Moving a 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 viewing pane.

To change the order of dimensions in the data viewing pane

  • Drag the dimension and drop it on the dimension where you want it to be located.
Relocating a Dimension

To remove a dimension from the data viewing pane

  • Drag the dimension you want to remove from the data viewing pane to the data slicing pane.

To drill down into a member

  • Double-click a dimension member in the data viewing pane. 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 viewing pane. In the following example, double-click the Drink member to drill down into its child members.

Drilling Down

If you want to display all the members in a level, double-click the parent level name in the data viewing pane. Level names are depicted with the shading of a button (for example, Product Family in the preceding example).

To slice through a dimension

  • To change the member in a dimension in the data slicing pane, click the down arrow on the members box, expand the members, and then select a new member. The cube data in the data viewing pane changes to reflect the change in the dimension member.
Slicing

Cube Browser has an internal memory limit that 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.

Show:
© 2014 Microsoft