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

How to drilldown query across Sheets

Hi,

I'm working with Bex 3.5. Actually I have defined a Query with characteristic 'Plant' in the rows. The idea is create a workbook based on this query but with the plant drilldown across different sheet. As an example:

Plant selection: Plant = A and Plant =B

Workbook view: Sheet 1 with correspondent values to Plant =A

Sheet 2 with correspondent values to Plant =B

Is it feasible? any help is welcome.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2009 at 05:23 PM

    Hi

    Yes you can do this. Insert the same query in two worksheets. (You have an option to insert query in the Bex Menu). Run the query for Plant = A in selection in the first worksheet and with Plant = B in the selection on the second worksheet.

    I hope I understood your question right.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2009 at 05:34 PM

    Hi,

    Thanks for your fast answer.

    I try your proposal but unfortunately it doesn't works. The workbook is a dynamic one, I mean it can be refreshed based on the user selection condition, it means that when refreshing the new selection conditions inserted by the user will be applicable for the whole sheets.

    The idea is create the sheets based on the user selection conditions. also I don't like to copy the same query and also change the filter conditions for the different plant (exists two many plants) and also this options will require a lot of maintenance work.

    Thanks in advance,

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      If you know VBA this is possible. You can have on BEX Sheet that will have main query with Plant drilled down.

      Then using the SAPBEX on refresh event, you can take the Result set and move it to one sheet per plant.

      Since the code will execute on Refresh it will automatically pickup any new additions or deletion to plants.

      One step to do before moving the data is to delete all old sheets with plant data on them

      Hope this gets you started

      Datta.

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.