This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
When would I want to use a Cube Sheet?
A Cube Sheet is a type of sheet that can be used any time a model designer needs to model multi-dimensional data entry.
Some common Cube sheet applications are below:
- Sales Managers need to input estimated sales in units and price, broken down by month, region, product line, and customer group.
- An Organization Structure Admin needs to input data for a particular month for several assumptions broken down by several regions. In a cube sheet, this could be displayed with assumptions down the side, regions across the top, and the months in a dropdown selector.
- A company needs to plan product-related expenses broken down by product-related dimensions. The manufacturing cost of a product might vary depending on the region, product, the fabrication machine that is used, and the customer.
- A company would like to plan 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, etc.).