Oracle Transactional Business Intelligence

Products Banner

Selecting the latest Order revision

283
Views
10
Comments

Summary

Need to retrieve the latest Orders revisions

Content

Hi,

  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

BR
Hany

 

Version

19d

Annotation 2020-02-04 231613.png

Comments