Skip to Content
Author's profile photo SESHA PS

How to get most recent record in Webi report


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.



Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.