Cube Browser

The Cube browser enables you to view a cube’s data. The cube must be processed before you can view its data in the Cube browser.

The Cube browser is displayed when in the OLAP Manager tree view you right-click a processed cube and click Browse Data, or when you click Browse Sample Data in the last step of the Cube wizard.

The Cube browser organizes the 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 cube are displayed in the slicer pane.

In this example, the data in the grid cells represents the measures according to the members that appear in the levels boxes for all the dimensions shown in the slicer pane. The specific members of the Customer Location dimension are spelled out across the grid column headings. Thus, the Unit Sales for all products, all promotion media, all promotions, all stores, and all store types in 1997 appears in the cells at the intersections of the Unit Sales row and the various columns displaying Customer Location dimension members (All Customers, Canada, Mexico, and so on).

The data in the Cube browser is actual data from a processed cube, or sample data when you are creating a cube in the Cube wizard.

Working in the Cube Browser

To browse the 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 existing dimension 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 a level beneath it, this next level is expanded.

Only the member you double-click is expanded. The other members retain their current levels in the data grid.

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 cube data in the data grid changes to reflect the change in the dimension member.

The Cube browser 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.