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. Go to Modeling > 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 > Dimension Attributes to create custom dimensions and populate them.
Before You Begin
- Required Permission: Model Management Access > Model.
- See Build Cube Sheets.
How You Get There
From the nav menu, select Modeling. In the Sheet menu, select User Assigned Sheets or Level Assigned Sheets to view the list of sheets in your model.
Add Custom Dimensions and Attributes and Select Values
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. If you choose to uncheck a value so that it won't be included on the sheet, the associated dimension still appears on the sheet. For example, you have tagged the G&A level with the West Coast attribute value. You uncheck West Coast to exclude it from the cube sheet. The G&A level still appears on the sheet and contributes to the attributes rollup on the sheet.