Oracle Transactional Business Intelligence
Selecting the latest Order revision
Need to retrieve the latest Orders revisions
While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision of the Order and ignore the old ones.
Is there a function to be used or filter logic to achieve that?
Below a sample of the analysis created and we need to show only the records for Revision 4.0
The Subject Areas used are:
Order Management - Order Headers Real Time
Order Management - Order Lines Real Time