In SAP BusinessObjects Web Intelligence, which action groups multiple query filters together so that they are evaluated as one combined AND statement?

Difficulty: Easy

Correct Answer: Select the filters and click the Group Filters button on the toolbar so that they form a single grouped condition.

Explanation:


Introduction / Context:
SAP BusinessObjects Web Intelligence allows report designers to use query filters to restrict the data that is retrieved from the underlying universe. When multiple filters are present, you sometimes need to group them together so that they are combined into one logical block, for example using a single AND condition. Understanding how to group query filters correctly in the query panel is a typical Web Intelligence certification topic.


Given Data / Assumptions:

  • We are working in the query panel of Web Intelligence.
  • Several query filters have already been defined.
  • We want those filters to act as one grouped condition combined by AND.
  • The toolbar in the query panel offers a Group Filters button.


Concept / Approach:
In Web Intelligence, you can group multiple filters by selecting them and then using the Group Filters function. This creates a bracketed block of filters that are processed together using the logical operator you have chosen, often AND. Grouping filters is useful when you need specific combinations of conditions, such as nesting AND and OR logic. Simply dragging filters into the report or merging queries does not create this type of logical grouping at the query level.


Step-by-Step Solution:
Step 1: Open the query panel and identify the filters that should be grouped. Step 2: Use the Control key or the mouse to select all relevant filters. Step 3: Click the Group Filters button on the query panel toolbar. Step 4: Confirm that the selected filters now appear inside one grouped block, usually connected with an AND operator. Step 5: Recognize that this behavior matches the description in option a.


Verification / Alternative check:
If you have ever built a query where some filters had to be combined with OR and others with AND, you probably noticed that it is necessary to group filters to get the correct logical structure. When you select multiple filters and press the Group Filters button, Web Intelligence visually groups them and uses brackets to show they form one logical expression. This method is described in option a and confirms that it is the correct approach to creating a single grouped AND statement.


Why Other Options Are Wrong:
Option b incorrectly suggests that converting to OR automatically creates an AND grouping, which is contradictory. Option c talks about dragging queries together, which merges or relates entire queries rather than grouping filters inside one query. Option d refers to dragging filters into the report body, which affects report level filtering or display but not query level grouping. Option e removes all filters, which obviously does not help in building a grouped condition in the query panel.


Common Pitfalls:
Many beginners in Web Intelligence confuse report filters with query filters and try to handle complex logic in the report layer alone. Another pitfall is to manually reorder filters without actually grouping them, which can produce unexpected results when AND and OR operators are mixed. Using the Group Filters button in the query panel ensures that the logical structure is explicit and is processed correctly by the query engine.


Final Answer:
To group several query filters into one combined AND statement, you should select the filters and click the Group Filters button on the toolbar so that they form a single grouped condition.

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion