Skip to Content
Author's profile photo Prashanth Konduru

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

If you see the above screen shot A-active and M-Modified versions are changed from 13 to 110.B-Backup version will be there as it is.


Note: Queries or query components that are freshly created using the NW04s BEx tool (ie., BW7.x query designer) will not have Backup version. Such queries can’t be reverted back to 3.x version.

Procedure to revert back the migrated query:

Inorder to revert back the migrated change back to 3.x we need back up version of the query or query component.

SAP has provided a standard program COMPONENT_RESTORE to migrate the changes back to original 3.x version.

The report COMPONENT_RESTORE overwrites the existing active version using backup version as a source and allows editing the query with BW 3.x Query Designer.

Steps to be performed:

  1. TX Se38 – Enter the program “COMPONENT_RESTORE”.
  2. Enter the Info provider and Component type

Here in our case we are trying to restore the backup version of the report, so I’m considering the component type as REP.

Other component Types:

3) Execute

4) This will display all the underlying queries which are build on that particular info provider. Select the Query which you want to restore and click on “transfer       Selection”

5) Click “Yes”

         

Now the query or query components are restored back to 3.x version.

        

Check the table RSZCOMPDIR entry for active and Modified versions will be restored back to 13.

KP

Assigned Tags

      28 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Hi Prashanth,

      Another good one from you.  Nicely explained.  Thanks for sharing.

      Regards,

      Krishna Chaitanya

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks KC for the comments...

      Author's profile photo Former Member
      Former Member

      As usual good piece of doc. Keep it up and looking forward next.

      Arshiyan

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Arshiyan ...

      Author's profile photo CH Raman
      CH Raman

      Good presentation with useful info. The program - COMPONENT_RESTORE Already shared by another author with piece info here. But you came with nice explanation. its worth to have it.

      Thanks

      Raman

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks RK:

      I'm not aware of this document you had posted... but i had a requirement. I found a Note posted by SAP on this and i thought of sharing the info with detailed information..

      FYI : There are lots of presentation with same content with different explanations on SCN ...

      Regards

      KP

      Author's profile photo seshu P
      seshu P

      Hi Prashanth,

      Helpful document ,  But Sorry to say you that some one already posted in SCN .

      http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2013/08/06/how-to-restore-the-query-from-7x-version-to-older-version

      But here in this document you mentioned  detail steps, including how to  find bex version is it 3.x /7.0 ?  from table RSZCOMPDIR.

       

      Regards,

      Seshu.P

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks for the link ...

      I'm not aware of this document you had posted... but i had a requirement. I found a Note posted by SAP on this and i thought of sharing the info with detailed information..

      FYI : There are lots of presentation with same content with different explanations on SCN ...

      Regards

      KP

      Author's profile photo Gopi B
      Gopi B

      Hi Prashanth,

      Nice explanation, Thanks for sharing 🙂

      Regards,

      Gopinath B

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Gopi 🙂

      Author's profile photo Martin Grob
      Martin Grob

      thanks for sharing

      Martin

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Hi KP,

      I understand that same information has been posted earlier as well but i must say the way you've presented is what makes your document unique.

      Step by step approach with proper information and scenario with detailed navigation thats the area where your experience counts.

      Appreciate the efforts.

      Regards,

      AL

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Anshu for your comments ... 🙂

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Hi Prashanth,

      I have seen people asking How to restore to older version of their queries. This is a perfect blog which addresses with a step by step approach. Simple one and smart program 🙂

      Regards,

      Suman

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Suman for your wonderful comments... and for rating the blog.

      Regards

      KP

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice presented prashanth.... Very nice document... 🙂

      Regards,

      SM

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks for the comments Satendra...

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi Prashanth,

      Good information..some times projects need this.

      thanks for sharing.

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Ganesh ..

      Author's profile photo Former Member
      Former Member

      Good info...Thanks for sharing.. 🙂

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Naveen ...

      Author's profile photo Former Member
      Former Member

      Hi Prashanth,

      Very useful document. Thanks for the useful information.

      Regards,

      Chandra Sekhar

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Chandra For your comments ....

      If you like my blog - rate the blog and LIKE it.

      Cheers

      KP 🙂

      Author's profile photo Former Member
      Former Member

      Very useful document Prashanth.

      Thank you for sharing it.

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Ravi ...

      Author's profile photo Former Member
      Former Member

      Hi Prashanth,

      Very useful document. Thanks for the useful information.

      Author's profile photo Prashanth konduru
      Prashanth konduru
      Blog Post Author

      Thanks Shaik for the comments...

      Author's profile photo Phani KV
      Phani KV

      Hi Prashanth,

      Nice document and very useful.

      Thanks,

      Phani.