Skip to Content
author's profile photo Former Member
Former Member

BI HR Extraction --- Issue in DATE selection --- need help.

Hi Experts,

I am Creating a HR View based on Tables ( PA0001, PA0002, PA0008, PA0009, PA0014 ) .

In every Table I have Start Date ( BEGDA ) and End Date ( ENDDA )

For Example : I have a employee 20117, for this employee I have start date and end date in all tables.

Table -


Start Date -
End Date

PA0001 -- 01.01.2002 -


31.12.9999

PA0002 -- 01.01.2002 -


31.12.9999

PA0008 -- 01.01.2002 -


31.01.2003

PA0008 -- 01.02.2003 -


31.01.2005

PA0008 -- 01.02.2005 -


31.12.9999

PA0009 -- 01.01.2002 -


31.05.2005

PA0009 -- 01.06.2005 -


31.12.9999

PA0014 -- 01.01.2002 -


31.12.9999

In PA0008 , His Basic Salary is Changed three times thatÂ’s the reason he has 3 records in the Table,

Same for PA0009, his Bank A/c No changed two times , he has two recordsÂ…

My Issue :

I have 0CALDAY, 0CALMONTH, 0CALYEAR in my CUBE.

My user will see the report every Month, how I can get Month wise data.

Do I have to write any routine or which date I have to assign to 0calday.

For Ex: if I want to see JAN 2008 data, how this data I will get in the Report?

I appreciate your suggestions.

Regards,

SHAIK

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 07:41 PM

    In characteristic restriction put condition

    Start Date >= 01.01.2008 End Date <= 01.31.2008

    Hope this will help

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Shouldn't it be Start Date <= 31.01.2008 End Date => 01.01.2008, because these are valid dates?

      But i see two problems

      if you have

      PA0001 -- 01.01.2008 -


      02.01.2008 A

      PA0001 -- 02.01.2008 -


      31.12.9999 B

      is A or B correct? But you want 0Calday, so this is not that importent. But do you want one row for every day from 02.01.2008 -


      31.12.9999?

      the other problem is

      the valid dates do not need to be the same, so you can't join.

      PA0001 -- 01.01.2008 -


      31.12.9999 B

      PA0002 -- 03.12.2007 -


      31.12.9999 C

      PA0002 -- 02.01.2008 -


      31.12.9999 D

      in fact on the 01.01.2008 you should have BC and on the 02.01.2008 BD. But there is an abap statement, i don't remeber right now, that can do the valid date split and join for you.

      I believe your problem can not be solved with a simple view

      hopefully this will help you.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 12:59 PM

    Why don' t you load the data to an InfoObject with time dependent attributes, it handles the dates correctly. You can also report on an InfoObject (eg. 0EMPLOYEE).

    Kind regards,

    Luc

    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.