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

How to create a Bex Query by coping a existing Query ?

Hi Experts,

I'm new to SAP BI, I want to make a copy of existing Bex Query. For example say there is a Bex Query called ZDays_OverDue in ODS called 0FIAR_O03. I want to take copy of it and rename the Query as ZDays_OverDue_1 and want to save it in same ODS (i.e 0FIAR_O03). How can I do it? I have tried RSZC T-code in BI Development, but I doesn't work. Shows a message "General control error".. Is there another way to do it ? Please Help me. Step by Step explanation please...

Thanks,

Regards,

Nimesha.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2012 at 11:02 AM

    Hi,

    Open the query ZDays_OverDue. Click on "Save as". There will be a prompt for the Technical name and description. Enter the Technical name and the description. A new query is created that is the copy of the first one.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 05, 2012 at 01:17 PM

    Hi

    In u r case , Just create the copy of that query by using the SAVE AS option . RSZC is used to copy the query for the two different infoprovider having the same characteristic between those 2 infoprovider.

    Hope u got it,

    Regards,

    RaviChandra

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 05, 2012 at 11:13 AM

    Hi Nimesha,

    Open the Query ZDays_Overdue in BEX Query Designer and give Save As and it will ask for the new Query name just give the desired name and click on save. The Query has been copied and it has been saved on the same infoprovider. So in your case the infoprovider is ODS 0FIAR_O03, it will contain both the original query and the copied query.

    Thanks

    Jay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2012 at 04:57 AM

    Problem solved......

    Thanks Guys...

    😊

    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.