Skip to Content

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:

s1.PNG

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 .

s2.PNG

If you observe Rank has shown 1 ,2 ,3 for 3 different records for Emp 107 as below.

s3.PNG

Now apply filter on rank with 1 then it will Table/output will display only one record with most recent data.

s4.PNG

Thanks.

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