Create a Transfer Cube Task
NOTE: For this example, make sure that there are Budget data or figures on your Future Year Model cube.
So to begin, we need to first add the Budget New member in the Actual VS Budget dimension as shown in the succeeding image. Make sure that there are exisitng data in the source cube which in this case is the Budget cube. Once the member is added, proceed to creating the Transfer cube task.
To create a New Cube Transfer:
1. From the PowerOLAP ribbon, go to Data tab, then in the Data Transfer control group select Transfer Cube icon or Transfer Data command.
The Transfer Cube Tasks dialog box is displayed.
2. To create a new cube transfer task, click Add.
The Select Source and Destination dialog box is displayed.
3. Specify a <name> to define the transfer cube task (e.g., From Budget to Budget New).
4. Specify the Source and Destination Cube using the drop down button.
Since for this exercise, we want to transfer data from within the same cube, simply select Future Year Model.
5. Click Next.
The Transfer Options dialog box is displayed.
This sets the values in destination with values from the source.
This leaves the values that are currently in the destination and add the new values from the source into the destination.
Allows user to write a simple formula where some calculations on the source values are performed before writing them to the destination.
- Skip Zeroes
No zero values will be brought from source to destination.
- Skip Aggregates
No aggregate values will be brought from source to destination.
- Skip Calculated Values
No values that are calculated or that existed because of a PowerOLAP formula will be brought from source to destination.
6. Enable the settings desired for the transfer cube task. For this example, the default settings are left enabled.
7. Click Next.
The Limit Source Cube dialog box is displayed.
The Limit Source Cube allows user to limit the source region. Within Transfer Cube the source can only consist of a single Member along each Dimension, allowing transfer of data from a single source Member to multiple destination Members but not transfer from multiple source Members to multiple destination Members.
8. Select a <Dimension> and a <Member> from where the data is going to come from. For this example, go to Dimensions list box and select Actual VS Budget and select the Budget member by ticking the appropriate check box.
9. Click Next.
The Destination Members dialog box is displayed.
10. Select a destination Dimension and Member.
For this example, select Actual VS Budget dimension then pick Budget New as destination member.
11. Click Next.
The Summary dialog box will be displayed as shown below:
12. Click Finish.
A Transfer Cube task is now created and the task name will appear in the Transfer Cube Tasks dialog box.
13. To process task, simply click the Execute button.
A prompt indicating that the task was successfully completed will appear.
14. Click OK button.
15. Back in the Transfer Cube Tasks dialog, click Done to return to main interface.
The task is saved within the PowerOLAP database and can be scheduled via the PowerOLAP® Scheduler. It could also be manually executed (internal to PowerOLAP®) by clicking the Execute button. The Clear Cube Tasks dialog box also provides facility to edit and delete any defined task.