Skip to Content

Bex query designer varibale for latest date data

Jun 22, 2017 at 07:33 AM


avatar image
Former Member

Hi Experts,

Please let me help to create a variable or formula to get latest instance data. Currently report is getting the headcount as per plant(location) basis ..for example X employee was in some Y plant in 01.2012 in 06.2013 he is other plant ,now he is again in 01.2017 in Y Plant ..

headcount-issue.jpg (141.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Jun 22, 2017 at 12:50 PM

I don't know the setup of your dataflow but I can generally say : HR data is mostly based upon time dependant Master data, so I guess you have to play with the keydate and time dependant attributes to see/count what is required. check out

you see the begda/endda -> date from / date to -> keydate in query definition properties will trigger the correct information

10 |10000 characters needed characters left characters exceeded