Copy Data Between Cube Sheet
This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Question
How do I copy data from one Cube
sheet to another?Answer
To transfer data from one Cube sheet
in your model to another Cube sheet in your model, you can follow the below steps:- Export the cube sheet from which you want to take the data.
- Populate the data in the import template for the new cube sheet.
- Modify the account and dimension names in the template so that they are unique. This is necessary so that you can create a unique set of mappings.
- Import the new Excel template to the cube you want to transfer data to and create new mappings.
For example, if you have dimension Price mapped to Price Cube 1 you would need
to change it in the template to have a unique name such as Price2 and then map it to
Price Cube 2 during import.
You could also create a formula to pull the data
from one Cube sheet to another using
Cube Metric
accounts.Cube sheets
have an account type available called
Cube Metric
s which allow you to
directly reference accounts outside of the cube that they reside in. Cube metric
accounts can contain any formula, removing the need for "trigger"
accounts.