Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multiple Queries in one Workbook - incl. Button "Information"


I'm having problems getting several Queries into one Workbook in BW 7.0.

Method 1

Open Query in BEx Analyzer

Change to the design mode and insert items: Analysis Grid, Navigation Pane, Text

Assign DP_2, i.e. a different query, to each.

Exit design mode


2 Queries in 1 workbook

Style (Color for filter is different). Any change disappears after refresh

Button for inserting "Information", e.g. User, refresh date, etc. only inserts/hides lines for first query.

The button seems to have some complicated VBA code assigned to it. As a none VBA expert I do not know how to copy and adapt the VBA. Perhaps there is a simple solution?

Method 2

Open Query in BEx Analyzer

Tools -> Copy Sheet

Change to disign mode

Assign DP_2 to items.

Exit design mode


The format (color, indention, etc.) for the Filter (Navigation Area) for 2nd query is too short.

The second query contains has two more characteristics than the first query. Therefore the filter is longer.

The formatting seems to have been copied from the first query because the last two characteristics have a different format.

Formatting either with Excel -> Format -> Cells or assigning style/ theme does not survive a refresh.

How can I create a refresh-resistant formatting

I am grateful for your help


Not what you were looking for? View more on this topic or Ask a question