![]() |
![]() |
Cube Building and Modifying Examples |
When you create a cube in SAS OLAP Cube Studio, the Cube Designer wizard enables you to create cube dimensions and add the needed levels and hierarchies to those dimensions. For time-specific dimensions, you can select from a list of supplied time hierarchies that will help you build the dimension and auto-populate the levels and some level properties for the cube.
Open the Cube Designer wizard and select the input data for the cube. Select Add on the Cube Designer - Dimensions page. This opens the Dimension Designer - General page. When you create a time dimension, you must select the TIME dimension type. See the following display.
Note: The Add (levels) function is always available for selection regardless
of the type of dimension you are creating. When you specify a TIME type dimension, the Add button
is converted to a drop-down list where you can select the Add (level) specific
function that you want to use.
Select the Add supplied time hierarchies option. On the Add Supplied page, the Input column drop-down list displays the available numeric values that have a date format applied to the column. This will default to the Date value if it is found in the data source list of columns. The Format and Informat values change, depending on the value selected in the Input column drop-down list. Select from the list of supplied time hierarchies to create the time levels. See the following display.
The hierarchy or hierarchies that are selected on the Add Supplied page are listed in the Hierarchies panel on the Dimension Designer - Hierarchies page. If there is only one hierarchy, as with this example, the hierarchy name is changed to match the dimension name. See the following display.
![]() |
![]() |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.