Creating a report where I need to provide the total time (units) and amount (rates) a Timekeeper (TK) is spending on an Invoice.
In the invoice each Timekeeper is associated with a Line Item. I.e., TK 1 is associated with Line Items, 3, 6, 10.
While the report is pulling in the correct time (units) and Line Items. The report is applying the Line Items to all TKs that are in said invoice.
As an example, the below shows which Line Items should go to said TK:
TK 1 is associated with Line Items, 3, 6, 10;
TK 2 is associated with Line Items 2, 15, 5;
TK 3 is associated with Line Items 1, 4, 8. etc
But the report is giving each TK all of the line items. so the report is providing a row for each Line Item for the TK which results in the following:
TK 1 is associated with Line Items,1,2,3,4,5,6,8,10, 15.
TK 2 is associated with Line Items,1,2,3,4,5,6,8,10,15.
TK 3 is associated with Line Items,1,2,3,4,5,6,8,10,15.
Which defeats the purpose of the report.
My ask is how do I correlate the TK with the correct Line Item?
I have used a cross join already. Still the same result. Is there an SQL Statement I should use or Query Calculation with SQL Statement to make this work?
I need the report to show me only the line items associated with said TK.
Thank you in advance.
------------------------------
Wesley Fornero
------------------------------
#CognosAnalyticswithWatson