Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Merged Cube Sheets

Merged Cube Sheets

We revert this functionality from production on 2021-05-28. We plan to redeliver it in a future update. If you already enabled this feature, you can continue using it.
With this release, we enable you to merge up to 3 modeled or cube sheets, saving you time and manual effort. When you merge the sheets, we automatically initiate cube calculations based on the presence information for the source sheet.
Watch the video:
 5m 5s

Create Merged Cube Sheets

Release: 2021-03-12
Now, when you create cube sheets, we provide a new
Create as Merged Cube
 check box.
Also, in the
Settings
tab on the sheet properties, we now display selection boxes for source sheets, enabling you to choose from available modeled sheets and cube sheets. You can choose up to 3 sheets.
See:

Merged Cube Sheet Dimensions

Release: 2021-03-12
We now filter the available custom dimensions to include only those already added to the source sheets. We also add the attributes of the available custom dimensions.
We automatically add any common dimensions to the canvas. Example: When all sheets contain the same dimension, we add that dimension to the canvas as a required dimension.
See:

Merged Cube Sheet Accounts

Release: 2021-03-12
You can add these accounts to merged cube sheets:
  • Cube calculated. You must select at least 1.
  • Cube metric.
  • Cube account groups.
The formulas of cube calculated accounts in a merged cube sheet must no longer evaluate to zero when the other accounts of the cube are zero. Instead, the data presence in the source sheets determines the intersections for the calculations.
See:

Available in Production Instances

Release: 2021-05-14
You can now request to enable merged cube sheets in your production instances.