Skip to Content
0

Bex query designer varibale for latest date data

Jun 22, 2017 at 07:33 AM

65

avatar image

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
0

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

http://myhelp.uky.edu/bw/EN/51/5aae399c1a6651e10000000a114084/content.htm

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

Share
10 |10000 characters needed characters left characters exceeded