Report

[Former Member]

Hi to all

I have a one report in bi7.0 time management , here i have a start date and end date and time in and time out , (when we use to swap this one is time in & when we use to go back in 6.0pm this one is time out) , here i have to calculate present and absent date ,can u give me any logic how will i calculate that one , plz help me

i will asign a full point

Thanks in advance

shalini

[Former Member]

Shalini,

If you perform any transformation on the data, then it betetr to have ODS or cube is just fine.

The logic if computing the attendence hours should be done in the update rules / transformations.

Ravi Thothadri

[Former Member]

You need to capture the TIME IN and TIME OUT and bring that data to BW and store in your reporting Cube or ODS.

The difference between these is the time of present and if the difference is 0, it is absent. This is the logic.

Pl consider the following:

1. Have time and time out in the reportig cube / ODS and extract this data from the source system where attendence is recorded.

2. Derive the difference in the report as a calculated key figure

There are some other ways of doing this, but this seems simple and easy to me.

Ravi Thothadri

[Former Member]

Hi ravi

Thanks for responce, i decided to make a genaric data sourse and take the fields in my cube , should i create a ods also , and how i will implement that logic that difference is 0 then absent , plz help me ,

Thanks in advance

shalini

[Former Member]

Hi Shalini,

If employee swiped in then data can be stored. If not then assume timed in is 9 AM. If he not timed out then also it ll be 9AM. so differece is 0 and we can conclude he is absent.

First we should know wht fields in extract structure are available.

Regards,

ARK

[Former Member]

hi ravi

Thanks alot for responce , i want to assign a point but i am getting error msg

Thanks alot

shalini

[Former Member]

Hi ARK

Actually that fields in r/3 sys so through the GDS using func module i m going to take that filelds in a cube , i am doing right step na ,,give me any idea

[Former Member]

You need to check if Time In and Time Out are Blank '#' then its absent other wise its present.