 |
|
| Cube Building and Modifying Examples |
Viewing a Cube in SAS OLAP Cube Studio
After you have built a cube in SAS OLAP Cube Studio, you can examine the contents of the cube with the View Cube function. The View Cube function is available from the Actions menu and from the cube context menu. The View Cube function is available for use only with physically built cubes. In addition, when you select the View Cube function, a connection to a SAS OLAP Server must be made.
When the View Cube function is selected, the View Cube dialog panel is loaded and a multidimensional view of the cube data is displayed in a table. By default, the first dimension (default hierarchy) of the cube is displayed on the row axis and the default measure is displayed on the column axis of the table. The dimensions that are not assigned to a row or column are automatically assigned to the slicer axis. The default member or All member is used to create the slicer filter. You can then drill into the dimensions for the cube and see figures for specific levels of the cube. In the View Cube dialog box you can choose to add level selections to the existing cube view, or you can select the check box Replace current selection to replace the existing levels in the display.
| Adding Level Data to a Cube View |
In this example, the option Replace current selection is not selected. A retailer is analyzing sales figures for outlets in various countries. In the initial cube view, the column axis displays the default measure for the Sum of ACTUAL sales. Displayed on the row axis is the default hierarchy for the geo (geography) dimension.
![[untitled graphic]](images/cubeview.gif)
In the following display, the row axis view is filtered on the products dimension to the FURNITURE level. Furniture-specific sales numbers are added to the existing row axis. The column axis is not modified and is still filtered on the Sum of ACTUAL sales.
![[untitled graphic]](images/cubeviewadd1.gif)
The following display shows continued filtering on the FURNITURE level down to the sales figures for sofas only.
![[untitled graphic]](images/cubeviewadd2.gif)
You can also filter on the column values. In this display, the time dimension is filtered down to the sales figures for the month of November. In addition, the products dimension has been filtered on beds for the row axis.
![[untitled graphic]](images/cubeviewadd3.gif)
In this display, the measure Sum of PREDICTED sales is added to the column axis. You can now compare the actual versus the predicted sales totals.
![[untitled graphic]](images/cubeviewadd4.gif)
| Replacing Level Data On A Cube View |
In this example, the option Replace current selection is checked. A retailer is analyzing sales figures for outlets in various countries. In the initial cube view, the column axis displays the default measure for the Sum of ACTUAL sales. Displayed on the row axis is the default hierarchy for the geo (geography) dimension.
![[untitled graphic]](images/cubeviewreplace1.gif)
In the following display, the row axis view is filtered on the products dimension to the FURNITURE level. Because the Replace current selection check box is selected, the original, default row selections were replaced. The column axis is not modified and is still filtered on the Sum of ACTUAL sales.
![[untitled graphic]](images/cubeviewreplace2.gif)
You can also filter on the column values. In this display, the time dimension is filtered down to the sales figures for the month of November. Because the Replace current selection check box is selected, the original, default column selections were replaced.
![[untitled graphic]](images/cubeviewreplace3.gif)
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.