Hello all,
I have created a query most of the infoobjects are time dependent. The data is personal and work information of an employee. what i am trying to do is display in the report employee and its work address (like building number, room number). Now the data in my BW system looks like this
Employee To Valid from Room Building
11 02/28/2006 01/01/1000
11 12/31/9999 03/01/2006 4555 HC
Now when I run the report and the data for employee 11 displays in two lines showing the 4555 and HC and also not assigned.
So basically what I am trying to do display data only for current time (current calendar day). I used the Key date and selected the SAP exit current calendar day but still I see two lines in report one for actual data (HC and 4555) and other line with "#" basically not assigned or no data.
Can some help me out in this .
Thanks