About editing an information object query

After defining a data set based on one or more information objects, use Information Object Query Builder to edit the query. Editing a query limits the returned data set so that it contains only data that is useful for a report design.

To edit a query using Information Object Query Builder, perform any of the following tasks:

Specify output columns for the query.

For a query that includes more than one information object, define joins.

Create parameters for which a user provides values when the query runs.

Define filters that limit the data returned from individual columns.

Specify a sort order for data rows.

Select columns that you want the query to group on.

Specify any aggregate columns that you want to filter in the query.

Select any localized sources for the query.

The Information Object Query Builder tools appear in the Actuate Information Objects Data Set editor, as shown in Figure 2-1.

Figure 2-1

Viewing an information object query in the data set editor

Copyright Actuate Corporation 2012