Creating Local Joins

  To create a local join:

  1. Select Insert, then Insert New Query to create the first query in the Interactive Reporting document file (BQY):

    The Insert Query dialog is displayed.

  2. Complete the steps for inserting a new query (described in the Insert Query topic).

  3. In the Query section, verify item data types and associated data values in source documents so that you know how to join them in the Interactive Reporting document file (BQY).

  4. Build the Request Line, and add server and local filters, data functions, and computations to the query as needed.

  5. Select Process.

    Tip:

    For consistent results, queries that use local joins should be placed after queries that generate the needed results.

  6. Select Insert, then Insert New Query to create the second query.

    (See step 1 for information on inserting a new query.)

    Add topics from the Table catalog to the Content pane, and build the Request line.

  7. In the Table catalog, select Local Results on the shortcut menu.

  8. In the Table catalog of the second query, select Local Results on the shortcut menu.

    A Local Results icon, Local Results icon displays in Elements.

  9. Expand the Local Results icon to display the Results table icon, Results table icon.

  10. Double-click a Results set or drag it to the Content pane.

    The Results set from the first query is displayed as a topic in the Content pane.

  11. In the Content pane, manually create a join between the Results set and another topic.

  12. Build the Request line and select Process.

    Local joins are processed on the client machine.

You can use Process All to process the queries, in which case the queries are processed in the order in which they are displayed in the Section catalog.

For example, in a Interactive Reporting document file with three queries, Query1, Query2, and Query3, the queries are executed in the order shown. If Query1 is a local join of the results of Query2 and Query3, it will still be processed first. If Query2 and Query3 have existing Results sets, then the local join in Query1 will occur first, before processing Query2 or Query3. If the Results sets for either Query2 or Query3 are not available, one or both of those queries are processed first in order to get the required results.