# 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.

<figure><img src="/files/8WNoetwO6rkhYUrEuAK0" alt=""><figcaption></figcaption></figure>

2. 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.&#x20;

{% hint style="info" %}
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.
{% endhint %}

<figure><img src="/files/0XUFZfE71BzXSFbgvcI2" alt=""><figcaption></figcaption></figure>

3. 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.

<figure><img src="/files/z3FG6VfQ86Dzp2UfB07y" alt=""><figcaption></figcaption></figure>

3. 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.&#x20;

<figure><img src="/files/8vfgVXv0SOKUpdtIIWsd" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/T3VxCs8nUjU92EBzg2r3" alt=""><figcaption></figcaption></figure>

4. 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.

<figure><img src="/files/lobmS0VVmkklpPnBycO8" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.