Merged Cube Sheets in Workday Adaptive Planning
Merged cube sheets in Workday Adaptive Planning allow you to combine data across multiple sheets and dimensions into a unified read-only structure. This is especially useful when you need to perform cross-dimensional calculations or report on data from multiple sources without creating duplicate logic. Merged cubes improve clarity, reduce complexity, and are a powerful modelling technique for advanced use cases.
What is a Merged Cube Sheet?
A Merged Cube Sheet combines data from multiple sheets (cube or modelled) into a read-only, calculated environment. It allows users to perform cross-dimensional or cross-sheet logic without creating performance drag or trigger dependencies.
When to Use Merged Cubes
Use Merged Cube Sheets when:
- You’re calculating across different sources (e.g. quantity from one sheet, price from another)
- You want to avoid using Trigger Accounts
- You need clean, consolidated logic for high-level dashboards or reporting
See how merged cubes can solve complex cross-sheet logic (and replace trigger accounts) in our Cube Sheet Formula Errors blog.
Use Case Example
You have:
- A modelled sheet tracking customer sales quantity
- A cube sheet holding product pricing
- A merged cube sheet calculating revenue = quantity × price
Because both source sheets are seeded, the Merged Cube Sheet evaluates safely without requiring a trigger.
Benefits of Merged Cubes
| Feature | Value |
|---|---|
| Cross-sheet logic | Perform calculations that would otherwise span disconnected sheets |
| Improved performance | Lower evaluation overhead compared to full cube logic with triggers |
| Read-only | Ensures data integrity and avoids manual overwrite |
| Ideal for reporting | Perfect for financial summaries and dashboards |
Limitations
- No data entry merged cubes are view and calculate only
- Slightly more setup complexity requires careful alignment of dimensions
- Can’t write back into source sheets merged sheets are used for reporting or derived logic
Related Glossary Terms
- Cube Sheets
The foundational structure that merged cubes build upon. - Trigger Accounts
Often replaced by merged cubes for more scalable calculation strategies.
Want to Build a Merged Cube?
GK Horizons helps clients structure efficient merged cubes for scalable logic across their models.
Schedule a Demo! Contact GK Horizons.
