Cube Sheet Builder
Cube sheets are designed for modeling complex sales forecasting they can contain multi-dimensional data input across a specified set of dimensions. You’ll use the Cube Sheet Builder, a three pane user interface, to define your cube:
Left Pane: Used to select custom dimensions and attributes and add them to the cube sheet.
Center Pane: Represents the data included in the cube sheet.
Right Pane: Used to set properties or select values on selected dimensions and attributes.
Dimensions and Attributes
Cube sheets must contain a set of dimensions. The center pane represents a list of all dimensions that are included in the cube sheet. The Time, Account, and Level dimensions are system dimensions that must be present in every cube sheet. You cannot remove them, but you can specify which of their elements are present in the cube. The asterisk (*) next to these dimensions indicate that they cannot be removed from the cube sheet.
A cube sheet can have up to a total of 50 systems dimensions, custom dimensions, and attributes.
Custom dimensions: You can add up to 7 custom dimensions to a cube sheet. You must create custom dimensions before you can include them in a cube sheet. Navigate to Modeling > Model Management > Dimensions to create custom dimensions and populate them.
Attributes: You must create attributes before you can include them in a cube sheet. Navigate to Modeling > Model Management > Dimension Attributes to create custom dimensions and populate them.
Add Custom Dimensions and Attributes and Select Values
Use the Cube Sheet Builder to select the dimension and attributes to include on your cube sheet:
From the left panel, search for the dimension or browse by clicking Dimensions or Attributes on the Elements tab.
Drag and drop a custom dimension or attribute on to the center panel to include it in the sheet. Adding an attribute automatically adds the associated dimension. An attribute cannot appear in a cube definition without its associated dimension.
Select the newly-added dimension or attribute. The right panel displays the associated properties.
(Custom dimensions only) select Edit Dimension on Sheet to allow users to edit elements of the dimension when they view the cube sheet.
Select the values to include on the sheet by searching or browsing. You can select a child element without selecting the parent.
Set the Display Options for the Time Dimension
Select the Time dimension from the center pane. In the right pane, select or clear these check boxes to set the display defaults when viewing the cube sheet in the sheet viewer:
|Time Property||Description||Can users override this default|
|Initial Balance||Shows the initial balance for the time slice. This option enables you to see any starting balance before the next planning period starts.||No|
|Month, Quarter, Year||The cube shows all the years of the current version and shows only those portions selected by the cube designer. For example, if you choose to show only quarters, the default sheet will show time based on quarters.||Yes|
The following table shows toolbar icons for the Cube Sheet Builder.
|Save||Save changes made to the cube sheet.|
|Sheet Properties||Manage sheet properties, including:
|Move Up, Move Down||Move the selected dimension or attribute up or down the list. This list controls the order in which the dimension appear in cube sheet menus.
Other move methods:
|Delete||Remove the selected custom dimension or attribute from the cube sheet.
Other remove methods: