How do I copy data from one Cube sheet to another?
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 Metrics 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.