BW Hierarchy Migration 3.5 to 7.3

[former_member196240]

Hello Experts,

I have a requirement to migrate hierarchy(InfoObject) from 3.5 to 7.3, i believe  the migration step itself indicates that some OSS Notes need implemented first in order to do this.

Could you please let me know those OSS messgaes & steps for migrating the hierarchy.

Appreciate your help!

Thanks,

Vinay

[former_member182346 · Accepted solution]

Try this to migrate transformation

http://www.ittestpapers.com/blogs/sap-bw---how-to-migrate-a-35-datasource-to-70.html

[former_member196240 · Accepted solution]

Hi Vinod,

More appreciated if you can provide any OSS note, indicating in which patch & version the migration is possible from 3.5 to 7.3.

So that i can install them if i'm not using such patch & version

Thanks,

Vinay

[former_member182346 · Accepted solution]

Hi Vinay,

we are on SAP BW 7.3 EhP 1 SP 6.

I guess this is the latest.

Thank-You.

Regards,

Vinod

[former_member182343]

Hi,

Rerer :

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/608c815f-178d-2e10-1a90-dd067ec5f...

WR,

Vijay

[former_member196240]

Hi Vijay,

Thanks for the quick turn around.

My bad i didn't mention the requirement properly, I need to migrate the bw transformation from 3.5 to 7.3.

Is there any OSS message which indicates in which patch & release its possible?

Also more appreciated if you can give me the steps to migrate 3.5 transformation to 7.3

Thanks in advance,

Vinay

[former_member182346]

Hi,

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 separate. 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.

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.

Thank-You.

Regards,

VInod Bokade

[former_member196240]

Hi Vinod,

Thank you so much for the detail explanation, however i dont have the requirement to migrate the data flow. I'm just looking for the transformation migration steps from 3.5 to 7.3.

Thanks,

Vinay

[ranganath_korata]

Right click on the Update rule or Transfer rule and choose the option to Create transformation ??

[RamanKorrapati]

Hi Vinay,

Please check the below links. might be useful.

http://scn.sap.com/thread/3306506

http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2012/01/08/bw-730-hierarchy-loading-...

http://help.sap.com/saphelp_nwes72/helpdata/en/ba/45db1795cd41ae83230ae01e882500/content.htm

Thanks