How to drilldown query across Sheets

[Former Member]

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.

[Former Member]

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,

[hai_murali_here]

Hi,

You can do this as follows...if my understandings are right.

1.Keep the Characteristic which you want to drill down across sheets as Free Characteristic.

2.Open the Query in workbook.

3.In the NavigationPane,select the values(Here it is a user input) for that Characteristic.Now right click,on that Characteristic in Navigation Pane,and select "Add Drilldown According to <Characteristic> in New Worksheets"

Now each worksheet will show the data for each value of the Characteristic.

Rgds,

Murali

[Former Member]

Hi,

I guess that you are talking about another BW version. I'm working with Bex 3.5 in this version the unique options for drilldown a characteristic are: Down and Across, option Drilldown across sheets is not in place in this version.

Thanks for your feedback.

[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.

[Former Member]

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.