A cube sheet allows for multi-dimensional data input in a few accounts across a potentially large set of dimensions. You can select any dimensions to place across the top of the sheet and down the side of the sheet, and adjust their view at any time. You can place up to five dimensions on the side, and change or reorder them. Each cell in a cube sheet can hold one number or formula, similar to how cells behave on standard sheets, but cube sheets cannot have splits.
When Would I Use a Cube Sheet?
A cube sheet can be used any time you need to model multi-dimensional data entry. For example:
- Sales Managers need to input estimated sales in units and price, broken down by month, region, product line, and customer group.
- An organization structure administrator needs to input data for a particular month for several assumptions broken down by several regions. In a cube sheet, this can be displayed with assumptions down the side, regions across the top, and the months in a drop-down selector.
- A company needs to plan product-related expenses broken down by product-related dimensions. For example, the manufacturing cost of a product might vary depending on the region, product, the fabrication machine that is used, and the customer.
- A company wants to show personnel expenses as an aggregate rather than by each person: large batch personnel modeling, where individual people are not identified, but instead total headcounts are reported split into different regions, departments, job codes, and so on.
Cube sheets appear along with other sheets on Sheets > Overview or as a user-assigned sheet on Modeling > Accounts > Assumptions.
Dimensions on Cube Sheets
Cube sheets are the most similar in look to standard sheets. However, with a cube sheet you have added dimensions from which to select specific dimension values. Cube sheets also support the use of attributes: level, account, or dimension to assist in filtering the sheet’s display. Up to seven custom dimensions can be added to a cube sheet’s design, plus the structural dimensions, levels, accounts, and time from the version selection.
From this possible total of ten dimensions, you have the ability to shift the display of both the column and row axis, nesting up to five dimensions in the rows (or vertical) axis.
Dimensions can also be added to the rows in a standard sheet design. But, depending on your model, it may be "best practice" to use a cube sheet.