> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/planning-tutorials/7-consolidate-plans-across-dimensions-using-cubes.md).
# 6 - Consolidate plans across dimensions using cubes
In this tutorial, you plan sales at the geography level and costs at the product level, with Cube enabled at plan creation. Both plans consolidate into a single profitability sheet despite their different granularities. Cubes keep all three sheets synced in real time as changes flow in either direction.
### Prerequisites
Before you start this tutorial, ensure you complete the first tutorial: [Introduction to Fabric Planning](/planning-tutorials/1-introduction-to-fabric-planning.md)
### Create a sales plan
In this section, you create a sales plan sheet at the region level and enable multidimensional allocation. Multidimensional allocation automatically allocates sales values you enter by region across category and sub-category.
1. In the *Northwind\_FMCG\_Plan*, select **New Planning Sheet** in the **Home** ribbon. Enter *Sales Plan* and select **Create**.
2. Configure the field assignments as follows from the **Measures Table**, **Date**, and **Geography** tables:
| Field | Value |
| ------- | ------------------------------------- |
| Rows | Region > Sub Region > City |
| Columns | Date hierarchy > Year, Quarter, Month |
| Values | 2025 Gross Revenue |
3. Select **Insert Column** > **Number** > **Copy from another series** > **2025 Gross Revenue**.
4. Enter *Sales Plan* as the Title. In the **Enable Multi-Dimension Allocation** section, select **Add Breakdown**.
5. In the **Add Breakdown** window, *2025 Gross Revenue* is automatically used as the reference measure. A default breakdown already exists with *Region*, *Sub Region,* and *City*. Edit it to add *Category* and *Sub Category* as additional dimensions. Select **Create**.
6. In the **Data Input** side panel, confirm the breakdown is added and select **Create**.
7. In the **Planning** ribbon, select **Totals** and enable **Column SubTotal** on the left. Expand the column hierarchy to show the quarters, and hide the *2025 Gross Revenue* column.
### Create a cost plan
In this section, you create a cost plan sheet at the category level and enable multidimensional allocation. You enter cost values at the *Category* level, and the cube automatically allocates across *Region*, *Subregion*, and *City*.
1. In the *Northwind\_FMCG\_Plan*, select **New Planning Sheet** in the **Home** ribbon. Enter *Cost Plan* and select **Create**.
2. Configure the field assignments as follows:
| Field | Value |
| ------- | ----------------------------------- |
| Rows | Category >Sub-Category |
| Columns | Date hierarchy—Year, Quarter, Month |
| Values | 2025 COGS |
3. Select **Insert Column** > **Number** > **Copy from another series** > **2025 Gross Revenue**.
4. Enter *Cost Plan* as the Title. In the **Enable Multi-Dimension Allocation** section, select **Add Breakdown**.
5. Create the breakdown as shown in the following image:
5. In the **Planning** ribbon, select **Totals** and enable **Column SubTotal** on the left. Expand the column hierarchy to show the quarters, and hide the *2025 COGS* column.
### Create a profitability sheet
In this section, you create a *Profitability* sheet that pulls in the *Sales Plan* and *Cost Plan* measures. This sheet consolidates both plans at their common grain and calculates *Gross Profit*.
1. In *Northwind\_FMCG\_Plan*, select **New Planning Sheet** in the **Home** ribbon. Enter *Profitability Sheet* and select **Create**.
2. Configure the field assignments as follows:
| Field | Value |
| ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Rows |
Region > Sub Region > City Category > Sub Category
(In the Data sidebar, expand From Sheets > Cube. Select Sales Plan and Cost Plan, and select Insert as measure).
|
3. Open the **Filter** side pane and set the year filter to 2025. Enable column subtotal on the left, and expand the column hierarchy to show the quarters. Observe that both measures are populated at the common Region > Sub Region > City > Category > Sub Category grain. The cube breakdown handles the allocation automatically.
4. In the **Planning** ribbon, select **Insert Column** > **Formula**. Configure the following options and select **Create**:
* **Title**: Planned Gross Profit
* **Formula**: `[Sales Plan] − [Cost Plan]`
* **Row aggregation**: Formula
* **Column aggregation**: Formula
Gross Profit now shows at every Region > Sub Region > City > Category > Sub Category combination and gets data from two measures that are at different dimensional levels.
### Real-time plan alignment
In this section, you see the three sheets working live and connected. You update a sales assumption in the *Sales Plan* sheet and watch it reflect instantly in the *Profitability* sheet, then update a cost value directly in the *Profitability* sheet and watch it flow back to the *Cost Plan* sheet with no reconciliation step, no re-entry, and no risk of the sheets falling out of sync.
1. Open the *Sales Plan* sheet. Double-click the *Americas g*rand total cell in the *Sales Plan* column. Append by 10%, and press **Enter**. This action updates the *Sales Plan* grand total value to 26,581 thousand.
2. Open the *Profitability* sheet. The cube updates the *Sales Plan* and the *Gross Profit* across all *Americas* categories and subcategories; a single assumption change at the region level is immediately reflected at every category and subcategory intersection. The *Sales Plan* grand total now matches the 26,581 thousand entered in the *Sales Plan* sheet.
3. In the *Profitability* sheet, under *Americas >* *Latin America* > *Curitiba* > *Beverages*, double-click the beverages grand total cell in the *Cost Plan* column. Append by 15% and press **Enter**. The *Cost Plan* grand total is updated to 14,174 thousand.
4. Open the *Cost Plan* sheet. Observe that the *Cost Plan* for *Beverages* is updated to 14,174 thousand. A revision made in the consolidated view flows back to the source plan. Planners can work at whichever level is most convenient, and the model stays aligned.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## 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, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/planning-tutorials/7-consolidate-plans-across-dimensions-using-cubes.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
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.
