OBIEE - compare dates in two reports

3713479

Report A & B each consists of two columns...Key & Transaction Date.

I want to create Report C consisting of the Keys in report B where  the Transaction Date in B for that Key is greater or equal to the date for the Transaction Date in A for that Key.

Report C filters

     The Key matches Report A

     The Key matches Report B

     The Transaction Date is equal to any Transaction Date in Report B

      The Transaction Date is greater or equal to the Transaction Date in Report A.

When I run Report C, the results are only partially correct.

Message was edited by: 3713479 at 4:20 PM EDT

Message was edited by: 3713479 The solution I used was to create a new column that was a concatenation of the date column and the customer key.

[Deleted User]

Any less information and I wouldn't even post this: