How to get most recent record in Webi report
Hi,
This document will be helpful in a scenario where we have multiple records with different dates but dimension is same /Getting most recent record in webi using date dimension.
Sample data:
Here Emp no 107 has Different date of joins but Emp name and sal same.
By using Rank function we can achieve most recent record by creating variable as below .
If you observe Rank has shown 1 ,2 ,3 for 3 different records for Emp 107 as below.
Now apply filter on rank with 1 then it will Table/output will display only one record with most recent data.
Thanks.
Be the first to leave a comment
You must be Logged on to comment or reply to a post.