Forecasts are often maintained separately by region, product, or other business dimensions, leading to inconsistencies across forecast views. Cube‑based forecasting makes it possible to generate and distribute forecasts across multiple dimensions with varying levels of granularity in a single step. As forecasts are updated, values remain synchronized across all related dimensions.
Forecasts are generated for the row dimensions included in the planning sheet. To forecast additional dimensions tha are not present in the current sheet, add breakdowns.
The dimensions and measures used to configure the cube can be sourced from the dataset without being added to the current sheet. The reference measure used for weighted allocation should have values for the future forecast period.
After the forecast cube is created, it will appear in the From Sheets section of the Data pane. The forecast can then be imported into other sheets with different granularities without creating separate forecasts for each sheet.
After the forecast cube is inserted into the planning sheet, updates made in either sheet sync automatically, streamlining the process of forecasting across dimensions.
