Clarity Service Management

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

05-29-2016 06:43 PM

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 

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.