Editing the query

Queries can be edited in order to adjust to the evolving requirements of the report. Through my work, I have come to know a simple fact: most reports are edited at one stage or another.

Editing is easy and is conducted in the same way a query is created, that is, by adding objects to the query or by removing some of them.

Getting ready

We want to extend the current query definition and add the model dimension to it so that we can analyze the sales data at a more detailed level.

How to do it...

On the report screen, we will click on the Edit button under the Data Access ribbon; this will open the Query Panel.

We will drag-and-drop the Model object and run the query.

The result table will remain the same. In order to present the additional ...

Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.