Data Point

 

Data Point Introduction

This is the concept of using Data Point to define a Transfer Cube, an Export Cube, a Clear Cube or IDS Source Region.

Creating a Data Point Transfer Cube Task

The succeeding steps would illustrate how to define a simple Cube transfer task using Data point.

To begin, create a new dimension and call it Paramaters with Members From Member and To Member and afterwards create the cube consisting of only this one dimension and name it the same thing, Parameters.

The image below shows a slice of the Parameters cube consisting of a single Dimension with fact data values as shown. The idea is to use the values in the Members as the source and destination for the transfer cube task.

 

To create a Transfer cube task using a Data Point:

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.

The steps from here until you reach the Limit Source Cube and Destination Members dialog is similar to the previous topic on  creating a simple Transfer Cube task.

3.   Specify a <name> to define the transfer cube task (e.g., From To).

4.   Specify the Source cube (i.e., Future Year Model).

5.   Specify the Destination cube (i.e., Future Year Model).

The image below shows the configuration made for the Transfer cube Task.

6.   Click Next.
The Transfer Options dialog box is displayed.

7.   Enable the settings desired for the transfer cube task. For this example, use the default settings.

8.   Click Next.
The Limit Source Cube dialog box is displayed.

Next step is to define the Source Data Point.

9.   Select a <Dimension> from the Dimensions list (i.e., Actual VS Budget).
This Dimension will contain the data that will be defined in the succeeding steps.

10. Click the Data Point tab to define the source and destination.

11. Using the Cube drop down button select a <Cube> (For this example select the Parameters cube).

12. Select a <Member> from the Parameters Dimension by clicking the drop down button (i.e., From Member).

13. Click Calc button.
Notice after that Actual appears beside Calc button.

14. Click Next.
The Destination Members dialog box is displayed.

Next step is to define the Destination Data Point.

15. Select a <Dimension> from the Dimensions list (i.e., Actual VS Budget).

16. Again, click the Data Point tab to define, this time, the destination.

17. Using the Cube drop down button select a <Cube> (i.e., Parameters).

18. Select a <Member> from the Parameters Dimension by clicking the drop down button (i.e., To Member).

19. Click Calc button.
Notice after that Budget appears beside Calc button.

20. Click Next.
The Summary dialog box is displayed containing settings configured for the cube task.

21. Click Finish to return to the Transfer Cube Tasks dialog.
The newly created task now appears in the dialog.

22. To process task, simply click the Execute button.
A prompt indicating that the task was successfully completed will appear.

23. Click OK button.

24. Back in the Transfer Cube Tasks dialog, click Done to return to main interface.

Now, try to create a slice out of the Future Year Model cube and configure the slice to display data for Budget. Notice that Budget data now displays the same data as with the Actual, as shown.