Relational queries - Query & Analysis Query Editor

Some reports, such as the relational self-service widgets, include buttons and actions that launch the Query & Analysis Query Definition dialog box, in which you can create relational queries. Queries can be summary or detail queries. Values are aggregated in a summary query but not aggregated in a detail query.

Some of the options when you create a query depend on the type of query, and the type of data it returns. This is a summary of all available steps when you create a query, but not all steps are required by all users:

1. Select the type of query to create.
2. Specify the data source and tables to query.
3. Specify the table columns to include in the query.
4. Specify the extraction type for each column.
5. Specify the sign notation of numeric extraction types.
6. Specify the scaling for each extraction type.
7. Specify the offset and length (for the Segment extraction type only).
8. Specify how items are sorted, and the order in which they are sorted.
9. Specify required data filters. For example, to extract data where an item has a value greater than a specified amount.
10. Specify additional filter conditions.