How to get most recent record in Webi report

[former_member199945]

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.