Building a Query
After you created a Web Intelligence report (see Steps to Create a Web Intelligence Report), you can build your query.
To build a query using the selected universe
| 1. | Drag and drop dimensions and measures that you want to include in the query from the universe into the Result Objects pane. Note the following: |
| • | Dimensions are qualitative and do not total a sum. A dimension object is the object being tracked; in other words, it can be considered the focus of the analysis. A dimension can be an object such as Service, Price, or Customer. Dimension objects retrieve the data that will provide the basis for analysis in a report. Dimension objects typically retrieve character-type data (customer names, resort names, etc.), or dates (years, quarters, reservation dates, etc.) |
| • | Measures are numerical values that mathematical functions work on. For example, a sales revenue column is a measure because you can determine a total or average its data. |
| 2. | From the Master perspective pane, select the objects on which you want to define query filters, and drag them to the Query Filters pane. |
| 3. | On the Query Filters pane, enter a value or select a value against the selected object. |
Example: You could filter for products created after January 1, 2024, at 12:00:00 AM (see the example in the screenshot above).
Tip:To preview the data for the selected objects, click the Data Preview Panel 
icon in the toolbar to display the Data Preview pane, the click Refresh.
| 4. | Click Run Query to create and view the report of the selected object. |
Reporter displays the report.
Note:For more information, see the Building Queries on Universes topic on the SAP Learning site.