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 differently from standard sheets when a user is editing or viewing a sheet in the Sheet Viewer, but in all other ways, the sheets behave identically to standard sheets. Cube sheets can be placed on any levels, their accounts are accessible through formulas or by placing them on standard sheets or in reports. Data can be imported into them and exported from them.
Cube sheets can provide pivot table interfaces of other sheets' data. For example, you could link to account data on another cube or model sheet through the use of a Cube Link Account.
Cube sheets appear along with other sheets on Sheets > Overview or as a user-assigned sheet on Modeling > Accounts > Assumptions.