Migration of 3.x Dataflow into 7.x

[Former Member]

Hello Everyone..

I am updating our 3.x dataflow to 7.x (7.3 specifically).  I have found some good documentation on the SDN but have a question or two.

When using the Migrate Data Flow option the newly generated DTP and transformations (RSDS nor TRCS) entries do not get updated into the transport.  At first I thought it was a setting in my Transport Connection but the Collection Mode is set to Automatic and the Grouping is set to In Dataflow Before and Afterwards.

Do DTP's and Transformation need to be manually added?

Lastly, I am making the changes to the Routines that we have in transformations.  Is best practice to disconnect the current transformation, save it, then reconnect the source to the target so the routines get updated with the current method?

Thanks!

Bill

[former_member182470 · Accepted solution]

Hi,

when you start migrating right from your Transfer Rules, Datasource and update rules, all changes will be saved in the Transport request. Only DTP s have to be collected separately. Rest all will be collected during the process.

The idea of disconnecting transformations is not a good idea.

Regards,

Suman

[Former Member · Accepted solution]

Hello Suman,

Can you explain how to start the migration from the Transfer rules? 

The documentation I have gotten from the SDN begins by right clicking on the 3.x datasource and choosing Migrate Dataflow.  I don't see anything like that under the Transfer Rules.

Thank you..

Bill

[former_member182470 · Accepted solution]

Hi,

Please follow this doc:  http://scn.sap.com/docs/DOC-11763

[Former Member]

Hi Bill Lomeli,

  As i have involved in the real time BW migration project, let me add my input as well which may help you.

1. Dont disturb the existing Update rule. Rightclick on the DSO/Cube and create transformation with its respective source object. This will help to incorporate the routine correctly and also to reconcile and compare and check the data. Once the transformation is created, clear the data set from traget DSO or Cube, then load using the two flows, one with update rule and another with transformation. This will help to check the number of records are same with two flows and also do the key figure summation using the two flow's datas.

2. Atlast you migrate the datasource & delete the update rule and send it to Quality and do the thorrow testing.

Thanks,

Umashankar

[former_member182346]

Hi, may be this will be helpful.

In SAP BW 7.3 we have a new wizard to migrate entire data flow from 3.X to 7.X. Prior to BW 7.3 we have to migrate each object separately. In 7.3 we can migrate entire dataflow to 7.0, the wizard also modifies the process chain to 7.0 flow. (i.e it adds the DTPs automatically to the process chain).

There is a new migration project concept where i you can group all the dataflows into different projects and carry out the migration once for each project. If there are issues during migration you can revert to 3.X flow by executing recovery for that particular project.

Below are step by step instructions with screenshots to convert 3.X dataflow to 7.X data flow in SAP BW 7.3.

1. Right click on the data source you want to migrate and select "Migrate Data Flow"

2. It will ask you for a migration project, we are going to create a new migration project so enter a name for the migration project and click on create button as shown below.

3. This will take to migration project screen, here select the objects that you want to migrate. You can select all the objects including process chains and then click on save. After that click on 'Migration/Recovery' button as shown below.

4. In the next screen select all the checkbox and click on 'Migrate/Recover' button

5. It will ask if want to run migration now, say yes.

6. It will show the migration status at the both of the screen. You can revert back to 3.X flow if there are any errors in the migration. To recover 3.X flow, click on 'Migration/Recover' button again. The next screen will show the objects that are already migrated and failed to migrate.

7. Select the objects that you want to recover and click on 'Migrate/Recover' button. It will ask if you want to migrate now, say yes.

8. It will show "Restore complete: No Error" message at the bottom of the screen after the recovery is complete.

9. If there are no errors in step 5, all the objects are successfully migrated to 7.X flow and it will display below 'Success" message at the bottom of the screen.

You can verify that all the objects are converted properly and also check the process chain to make sure that DTPs are added correctly.

[Former Member]

Hi Bill,

In this SAP BW Promising features doc, you can find the migration option.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0422780-97b8-2f10-a08c-9f375d205...

Hope it gives idea how to proceed!

Thanks,

RAM

[Former Member]

Hi Bill,

Not sure if you tryied this, but can you check by RSMIGRATE t-code.

This t-code has many functions by which you don;t need to migrate each indivitual components.

Regards,

Ganesh