How to restore back the migrated Query from 7.x to BW3.x Version.

I had came across a situation where i need to restore the back up version of the migrated BEx query. In my blog I’m trying to provide steps for Migration of a BEx query and restoring the back up version procedure as well.

Brief:

• – If a BEx Query in BW 7.x is using only the features which are also available in BW3.x, then it is in general possible that the Query definition can be opened with Query designer of BW3.x as well.
• – The case is different if the query is designed with BW 7.x features, BW7.x offer additional features which are not available in BW3.x version of query designer.
• – If a query definition of 3.x version is opened and saved using BW 7.x version query designer, it means the 7.x version query is not editable or compatible with the version BW 3.x.
• – If an attempt made to open a BEx query of version BW7.x in BW3.x query designer we will get the below error message.

This component was edited with a more recent version of the Editor. You also have to use the more recent version to edit further. Further processing not possible. Update your front end’.

In order to overcome the potential problems in case of undesired or occasional migration of queries or reusable query components from version 3.x to version 7.x, SAP has come up with an automatic procedure to revert back the migrated change.

First we will check the migration steps to migrate the BEx query which is build on 3.x.

• Before migration of a BEx query check the table RSZCOMPDIR ( ) to verify the” version of reporting component”.

        Pass the Query Technical name as input field in COMPID – Execute.

        Check the output attached below.

Here you can see 3 version of a BEX query A- active, M-modified and B – back up versions.

If the version of the reporting component is less than 100, it means the query is not migrated. If version of the reporting component is greater than 100, then the query is migrated.

• If you see the screen shot the query is not migrated as the versions of reporting component is 13.

Migration:

If a BEx query is opened in a new tool NW04s BEx query designer and saved the query will be automatically gets migrated to BW 7.x version query.

— Open the 3.x query in 7.x query designer. We will get the below message:

— Save the query. Query is migrated to new version.

You can check if the query is migrated from 3.x to 7.x in the RSZCOMPDIR table. The “version of reporting component” will be changed to greater than 100.

  Check the screen shot attached below