Creating a Multiple-Result-Set Analysis

You can combine multiple result sets by using set operators, thus using data from multiple subject areas.

  To create a multiple-result-set cross-subject area analysis by using set operators:

  1. Access Transactional Business Intelligence.

  2. Select the Criteria tab.

  3. Right click on the desired Subject Area and select the desired column.

  4. Click OK.

  5. Repeat Steps 2 and 3 for each subject area and column to use in the cross-subject area analysis.

  6. Select the Results tab.

Figure 97, Example of Combining Personal Status Change from Person Subject Area is an example of a multiple-set query that is a union of two result subsets combining employees personal status change from the Person subject area.

Figure 97. Example of Combining Personal Status Change from Person Subject Area

This screen shot shows an example of combining personal status change from the person subject area.

Figure 98, Example of Combining Personal Status Change from Worker Assignment Subject Area is an example of a multiple-set query that is a union of two result subsets combining employees personal status change from the Worker Assignment subject area.

Figure 98. Example of Combining Personal Status Change from Worker Assignment Subject Area

This screen shot shows an example of combining personal status change from the worker assignment subject area.

Figure 99, Sample Results of Multiple-Result-Set Query illustrates the results of a multiple-result cross-subject area query.

Figure 99. Sample Results of Multiple-Result-Set Query

This screen shot shows an example of the results of a multiple-result-set query.