Skip to Content
avatar image
Former Member

Bex query designer varibale for latest date data

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    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

    Add comment
    10|10000 characters needed characters exceeded