metrics from different source

[matrixfree]

Hello,

- We have these 2 query subjects: Billable as well as NonBillable
- Both query subjects have 5 identical query items: Group, Employee, Status, Day, Task
- Billable query subject has an additional Query Item called: Contract
- Both query subjects have their own NumberHours metrics:
NumberHoursBillable = number of hours that the employee has invested in a particular Task of a particular Contract
NumberHoursNonBillable = number of hours that the employee has invested in a particular Task not related to any Contract what so ever

We are able to create 1 list report that displays the 5 columns: Group, Employee, Contract, Status, Day, Task as well as the related metric named [NumberHoursBillable]
|Group| Employee|Contract| Status| Day| Task| NumberHoursBillable|


We are also able to create another List report that displays the 4 columns: Group, Employee, Contract, Status, Day, Task as the related metric named [NumberHoursNonBillable]
|Group| Employee| Status| Day| Task| NumberHoursBillable|

Now, we need to display the 2 metrics but inside only one list report (or crossTab). Is that even possible because of the fact that we are dealing with 2 different metrics from 2 different
query subjects and how ?

Thanks to anyone for any valuable information!

[bdbits]

You can add a 'dummy' [Contract] data item to the second query so the query result sets are the same, then do a union in Report Studio.

https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.1.doc/t_cr_rptstd_wrkdat_create_union_query_rel.html%23cr_rptstd_wrkdat_create_union_query_rel