Plan across multiple dimensions with cubes

Traditional multidimensional planning solutions often require complex data models, backend processing, and ongoing maintenance to support partitions, staging environments, and dependent measures. Fabric Plan allows you to create multidimensional cubes directly on your semantic model and simplifies planning by eliminating the need for backend cube modeling.

Allocate data across multiple dimensions

Cubes enable multidimensional allocations for plans, budgets, forecasts, and other data input measures.

• Use reference measures and dimensions that are not part of the current report.
• Allocate values based on the proportional weights of a driver measure, such as revenue, headcount, or historical sales.
• Distribute values accurately across business units, products, regions, or time periods.

Synchronize planning sheets

Cubes support bidirectional synchronization between connected planning sheets at different levels of granularity.

• Automatically aggregate changes from detailed planning sheets into the original planning sheet.
• Distribute changes from the original planning sheet to connected planning sheets based on configured allocation rules.
• Keep summarized and detailed plans synchronized while preserving the defined allocation logic.

This approach simplifies complex allocation scenarios while ensuring that plans remain consistent across multiple dimensions and planning models. Learn more about how cubes and multi-dimensional allocations work.

In this module, you learn how to configure cubes for multidimensional expense allocation.