Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OBIEE - compare dates in two reports
3713479
Rank 4 - Community Specialist
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.
0