-
Open the editor from a report.
For example, click Edit query in a relational self-service widget.
-
From the Query Type
list, select Summary or Detail.
-
From the Product
list, select the data source for your query.
Each query has a number of filters for which you must specify
values. After you select the data source, the first filter is added to the
Filters table.
-
Click the Lookup
icon of each item in the Filters table and select a value.
After you select a value for a filter, further filters are added to the
Filter table, until all required filters are listed.
-
Click the Settings
icon of each filter and specify the filter options.
The options vary according to the type of filter.
-
In the Available columns pane, double-click columns to add them as outputs of your query.
To add filters, in addition to the required filters, click an available
column and click the Up arrow.
Each output of a query has an extraction type and a sort order.
-
Click OK.
The results of the query are displayed.