When you view a cube sheet or modeled sheet, the sheet displays a grid of values with one dimension across the top of the grid and one or more other dimensions down the left side of the grid. All other dimensions are displayed as drop-down selectors above the grid.
To change dimensions or dimension values:
- Change the values being shown in the grid: Selecting a different value in one of the dimension selectors refreshes the grid to show the values corresponding to the new set of dimensions. For example, if the dimension was present in the dimension selectors and was currently set to Rent, changing that selection to Interest Expense refreshes the grid and shows values of the Interest Expense account instead of the values of the Rent account that had previously been present.
- Change which dimensions are shown on the axes of the grid:
- You can drag an entire dimension either onto the top of the grid (on top of a column header) or onto the left side of the grid (on top of a row header).
- The values selected in the dimension selectors, as well as the choice of which dimensions appear on the axes of the grid, are both changeable. In the toolbar, click Change Dimensions .
On Modeled Sheets, dimension attributes can act as filters for dimension values. Choosing a dimension attribute value limits the list of available dimension values. Two attribute columns can drive the selections in the dimension column.
Two attribute columns can drive the available selections in the dimension column. As an example, by selecting a product group and product availability first, users will only see a list of relevant products.