OVERVIEW

This document describes the steps to migrate 3x data sources and transformations to BI 7.0.

Steps with an example

I am just considering an LO data source for Sales and distribution, Sales document item data -2LIS_12_VCHDR.

capture.PNG

So, here you can clearly see that the data source is of 3x version.

capture.PNG

If you go to the transformation of this same data source, you can see that the transformation is of 3x version.

Migration of Data Source

So, we can start our migration of data source, assuming that the data source is already replicated. Note that, at the time of replication itself, it may ask for migration through a pop-up window. There also you can do migration. Else, you can migrate the Data Source from RSDS.

capture.PNG

Here, enter the Data Source name and Source system name, and click on that migrate tab as shown in the figure.


You can also migrate through the menu bar as shown below.

capture.PNG

Or you can migrate by right clicking on the Data Source and clicking on Migrate as shown below.

capture.PNG

Here, you will get a pop-up window as shown below.

capture.PNG

W/0 Export – Once migrated to 7.0 through this option, you cannot migrate back to 3x.

With Export – Once migrated to 7.0 through this option, you can migrate back to 3x.

So, select the option as per the need. In this example, I am opting for With Export.

Now, the Data Source will get migrated to 7.0 version. You can check it under Data Source tab in RSA1.

capture.PNG

So, now we can clearly see that our Data Source is in 7.0 version.


Migration of Transformation

We can migrate our transformation. Find our data source in RSA1 Infoprovider tab.

capture.PNG

Right click on the Transformation -> Additional Functions -> Create Transformation.

capture.PNG


You will get this screen. Here, you can either copy the 3x InfoSource to a new InfoSource or you can assign this to the same existing InfoSource. Here, I am selecting the first option, click OK.

capture.PNG


Now, this window will come where you need to give a new InfoSource name. Here, I had given the name starting with Z followed by the original Data Source name. Now, click OK.

capture.PNG

Click OK.


Now, we can see our new inactive transformation. Open it and activate it.

capture.PNG

capture.PNG


Now our transformation is active.

Now, we need to create mapping between the cube and the Data Source. So, right click on our new Info Source and create transformation

capture.PNG

capture.PNG

Here, everything will be already mapped. Just activate the transformation.

Now, you can create DTP and do the data loading.

capture.PNG

Now, in any case, if you want to restore the Data Source back to 3x version from 7.0 version, just come to RSDS, give our migrated Data Source name and source system name, come to menu bar as shown below.

capture.PNG


Give Restore 3.x Data Source.

***************** End of Document ******************


Thanks and have a nice day

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

    1. Jalina Vincent

      Hi,

      Good doc. I just want to know if there are some Routines available in 3.x flow.

      After Migration, Will i able to see the same code in Transformations ? Any step we need to do for Routines ?

      Thanks.

      (0) 

Leave a Reply