CABI4::. CA Bussiness Intelligence: Building a Subquery report

Document created by TMACUL Champion on May 29, 2016Last modified by Flavio_Tamaki on Mar 29, 2017
Version 3Show Document
  • View in full screen mode

In the example images below is the reference to Service Desk solution tickets table, therefore, we seek the selected ID in Query 2 (secondary), do not exist in Query 1 Primary.

 

ImageDescription
1. In Query 1 run your selection
CA BI Sub Query 012. Create a second Query 2 and run your selection
 CA BI Sub Query 02

CA BI Sub Query 01

3. Select the "Off the list"

CA BI Sub Query 03

CA BI Sub Query 02

4. Select the "Result from another query"

CA BI Sub Query 04

 

CA BI Sub Query 03

5. Select the query and the desired column in the example there is only one Query.

CA BI Sub Query 05

CA BI Sub Query 04

6. Result after run

CA BI Sub Query 06

CA BI Sub Query 05

7. Final: result: The report

 

 

CA Bussiness Intelligence: Subquery - Português

 

 

CABI4::. Summary - BOXI for CA SDM 

4 people found this helpful

Attachments

    Outcomes