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

Multi queries BEx 7

Hi,

How do I insert the second or third query in a saved workbook in BEx 7 ?

Thanks,

Shmulik

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 04, 2012 at 12:31 PM

    Hi,

    Please check the below steps:

    1. Create queries you would like to join.

    2. Open one of the queries in BEx Analyzer and save it as a workbook.

    3. Create two additional tabs in the workbook, and give them names (e.g., query2, results)

    4. Edit the query2 tab by adding design items: click BEx Analyzer > Design Toolbar > Insert Analysis Grid

    5. Click on the Properties dialog box, change Data Provider's name and click create button.

    6. Choose the second query and confirm your choice.

    7. Create a table, on the result tab, that merge data form both queries. Save the workbook.

    Also check the below link:

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

    regards,

    Rajesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2012 at 01:19 PM

    Hi Shmulik,

    I think you can find the answer of your question in details in this documents:

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d032116a-1ba6-2e10-8db6-d84e7dcc9975?QuickLink=index&overridelayout=true

    Regards

    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.