Skip to Content
author's profile photo Former Member
Former Member

Convert 3.x queries to BEx 7 version

Hello Gurus,

My company has been using BW for a long period and we have thousands of BEx 3.x queries. We want to convert all of them into BEx 7 version.

I have tried to use RFC function RSZ_X_COMPONENT_SET_NEW but it did not help.

Does anybody know how to convert them automatically?

Any input is appreciated.

Thanks,

Frank

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on May 03, 2013 at 02:15 PM

    We upgraded our 3.5 system to 7.0 in 2010. We attempted to use batch approaches, but they were so full of problems that we reverted to manually converting.. not only queries but also workbooks. There is a lot of manual work involved.. open the query in query designer 7, then save it to migrate it. You may need to correct some 3.5 object attributes that are incompatible with bex 7. Then you open the workbooks in Bex 7, accept the migration proposal, and then clean up the changes that the VBA Workbook migration program may have added. Navigation panes and text elements are a particular pain.

    We did require that end user who had created ad hoc queries and workbooks be responsible for their own conversion.

    Good luck !

    Do note that the new SAP-GUI 7.3 does NOT contain the Bex 3.5 tools, so all Bex 3.5 users MUST upgrade and migrate if they want to stay on support for their SAP-GUI.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 03, 2013 at 07:39 AM

    Frank,

    Check whether the below link is helpful

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

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 03, 2013 at 08:34 AM

    Hello Frank,

    actual there is no batch-conversion tool from SAP avaiable.

    You will have to use Query-Designer 7.x to migrate manual.

    The function module mentioned above is only for saving queries. I have implemented such a report for a customer, and it was very difficult: You will have to post the new structure format ( meaning global elements on top node, one SHT-Node for the Sheet and one SOB-node for the filters ). Additional, you will have to merge some attributes within the Range and Selection-Informations.

    Kind regards,

    Hendrik

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Hendrik,

      Yes I agree with you. The function has so many parameters and I don't think it's safe to use it.

      Manually save the queries will be our last choice if we can't find out any auto solutions.

      Do you think we can use Excel VBA to save the queries?

      Thanks,

      Frank

  • Posted on May 03, 2013 at 10:54 AM

    Hi Frank,

    You can try this way. Opening queries in BEx Query designer 7.x version automatically add components of 7.x to the query and eventually upgrades it to 7.x version. So you just need to open a query in the 7.x query designer and it will be upgarded.

    If you won't get any automate option then you can try using above manual one.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 06, 2013 at 12:11 PM

    Hi,

    Converting a bex query/report from 3.X format to 7.0 format is simple and easy. You just need to open 3.5 query in 7.0 designer and save it. The query will be saved as a 7.0 query. One thing to keep in mind is you can no longer edit this query using 3.X query designer.

    I dont think there is any FM or any prog or any process available to convert the query automatically from 3.x to 7.x

    Regards,

    Verma

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.