Creating content with the Query & Analysis Query Editor
To create content with the Query and Analysis query editor:
Open the editor from a report.
For example, click Edit query in a relational self-service widget.
Select Summary or Detail from the Query Type list.
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.
Note: 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.