Create multi-dimensional forecasts

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.

Configure additional 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.

1. Click Add Breakdown in the forecast configuration.

1. The first breakdown is set to the row dimensions in the sheet. To configure the cube, select Add to define the breakdown dimensions and choose a reference measure to drive allocation weights. Select Create to create the cube.

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.

1. Complete the forecast configuration and create the forecast.

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.

1. To import a forecast cube into a different planning sheet, go to Data > From Sheets and select More(...) > Insert as a measure for that cube.

After the forecast cube is inserted into the planning sheet, updates made in either sheet sync automatically, streamlining the process of forecasting across dimensions.

1. Forecast values are distributed evenly across dimensions in the second sheet. Select a cell to redistribute values based on the measure weights in the second sheet.