Skip to Content
K D

How to show only current data in report and not all time dependent

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2008 at 12:54 AM

    It looks like you are reporting directly off of the 0EMPLOYEE Master data object. So, with that assumption, you could add a filter on both Date To and Date From where DATETO >= 0DAT and DATEFROM <= 0DAT where 0DAT is the 0CALDAY variable that returns today's date.

    Make sure the BEx variable 0DAT is activated in your system -- it's a business content variable, so you can install it and transport it up if you need to.

    Good Luck!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2008 at 03:40 AM

    Hi Cathy,

    try restricting the the characteristics Room and Building with ># value

    For this right click on the characteristic and go to fixed values.

    Then from the drop down which is in the left select Interval and from the drop down to the right select Greater Than

    Now click on the # value and transfer it to the right.

    Try it out and see whether this workaround fixes your problem.....

    Regards,

    Rakesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.