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

[Former Member]

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

[Former Member]

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

[Former Member]

In characteristic restriction put condition

Start Date >= 01.01.2008 End Date <= 01.31.2008

Hope this will help

[Former Member]

Dear RK,

i am not getting the date properly in cube.

I am explaining the issue again.

I have created a view in R/3 based on the above tables i have selected all the fields that i want from that tables.

In the view I want a date which will populate the 0CALDAY. i can choose only one date |(BEGDA or ENDDA) from any table (PA0014, PA008 and so on). If i choose any one date only the records in the particular table are coming.

The requirement is to get the values of Basic pay which is stored in PA008.

And HRA, Transportation etc. stored in PA0014. Basic pay and the Allowances have to be seen by the user every month,These values must come together in the report. If i take the date of PA008 only one record of Basic pay will come , if i take the date of PA0014 then only the values of HRA, Transportation are coming.

how to get this for a particular month entered.

regards,

jameel.

[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.