Limitations of Local Results and Local Joins

You cannot use any governors with local results topics as part of the query. The following are governors accessed from the Query Options dialog box:

You cannot have more than one local join per local results topic. When setting up a query using a local results topic, you cannot have more than one local join between the local results topic and another topic/local results topic.

You cannot set query limits on local results topic items. Limits must be set in the query/result sections of the query that produces the local results. Attempting to set a query limit on a local results topic item invokes the following error message: “Unable to retrieve value list for a computed or aggregate request item”.

You cannot aggregate local results tables.

You cannot process local results data to a table.

You cannot have more than one limit local join. A limit local join involves two topics, one of which is a local results topics. A local results item is used as a limit to the other topic. Attempting to define more than one limit local join invokes the following error message: “This query contains a local results object involved in a join limit. It is not possible to have other local results objects when you have a local join limit”.

You cannot combine limit local joins with local joins. Attempting to combine a limit local join and local join invokes the following error message: “This query contains a local results object involved in a join limit. It is not possible to have other local results objects when you have a local join limit”.

You should expect compromised performance when a query is associated with large local results sets. This is expected behavior since Interactive Reporting Studio is not a database.

You cannot use metatopics with local results. You cannot promote a local results topic to a metatopic or add a local results topic item as a metatopic item. The Promote To Meta Topic and Add Meta Topic Item DataModel menu options are not available for local results topics and topic items.

You cannot access or change properties for local results topic items. Properties include remarks, number formatting, aggregate/date/string functions, data types, and name.

You cannot have query request line computed columns from local results topic items. The Add Computed Item menu option is not available for local results topic items.

You cannot use Append Query features of unions or intersections with local results topic items. The Append Query menu option is not available when a local result topic is part of a query.