Create and define IDS task to Push Fact Data from a Local Cube up to a Remote Cube


1.   First, open a PowerOLAP database (UsingPO.olp) located in your local machine.

2.   From the PowerOLAP ribbon, go to Data tab, then in the Data Transfer control group select Internet Data Services command.
This will show the IDS dialog box.

3.   Select the Cube that you want to insert the IDS task into (For this example, select Future Year Model).

4.   Click Add to begin configuring a web service source. This will show the Configure Source dialog box.

5.   In the Configure Source dialog box, specify the Name of the project (Push Data for Canada Sales), and name of the server. Remember to check Secure Connection checkbox if the connection to server is secured.

When specifying a PowerOLAP server that uses a different port number CLICK THIS link

Note: When specifying a PowerOLAP Server that uses a different port number refer to the topic Connecting to SCP running on the same machine as the IDS Web.

 

6.   Select a Database and Cube from the drop-down menu (click on the Refresh buttons to view the available databases and cubes). Specify the username and password for a secure database.
For this example, select UsingPO Canada as database and Future Year Canada as Cube.

7.   Select Next.

For this example we want to update the Fact Data of the remote Cube (Future Year Canada) by pushing the data residing in your local cube (Future Year Model).

8.   In the succeeding dialog box, enable the option to Update Remote Database (see the boxed radio button below).
You may also set other options for your IDS task by enabling or disabling the checkboxes.
For this demonstration follow the configuration of the options of the dialog box below.

9.   Select Next. Depending on what you want the task to do; PowerOLAP may prompt you for more information concerning your Dimensions.

Since the remote cube does not contain the Regions, dimension we need to specify that the fact data we are going to push up into the remote cube (Future Year Canada) are actually fact data for the Canada region.

10. In the succeeding dialog box, select from the drop-down menu a region where PowerOLAP will get the fact data to populate the remote cube once the IDS task has been executed. For this instance, select Canada.

11. Select Next again.

12. Configure the options to determine data elements that will be pushed up to the remote database.

13. After setting up the options select Next.

14. Click Finish to close Summary dialog box.

 

15. Back in the Internet Data Services dialog box, click Done.

This completes IDS task creation.

 
 
 
 

Seeing the Results

To check if remote Cube will actually be updated by fact data coming from local Cube when this IDS task is executed:

1.   First, create a new slice for the Future Year Model cube of the UsingPO.olp database.

Note: Remember that in the previous exercise we populated our local Cube (Future Year Model) with fact data from our remote Cube (Future Year Canada). Once you create a new slice you will see that the intersections for Canada and Sales regions have now changed to the values that we pulled from the remote Cube.

2.   Change the fact data values for the Canada Region, as shown in the succeeding image.

3.   Open your IDS dialog box and click Execute to execute task.
You will get a message box that tells you the task has been completed successfully. Select Done.

Now when you open the UsingPO Canada.olp in the modeler and create a Slice for the Future Year Canada cube, you will notice that the Cube has now been populated by the fact data values coming from the local Cube.

 
 
 

Please see related topic: