Skip to Content
2
Mar 08, 2013 at 10:35 PM

Modify Date between DSO and infocube

20 Views

Hi experts,

I have to load data in full mode with a filter on period on DTP between DSO and Infocube.

I am comfortable with it , but there is a type of data that I have to manage to avoid me big changes on my flow.

To simplify, let’s say data is coming from DSO as following:

Employee

WorkDate

ApprovDate

Hours

A

08/02/2013

10/03/2013

5

And In stvarv, I will create 2 variables as following:

First Date of current period (FDCP): 01/03/2013

Last Date of current period (LDCP): 31/03/2013

So what I have to do, is to control that approvdate is between FDCP and LDCP, and also superior to workdate.

If the 3 conditions are respected, I have to set the value of Approvaldate in Wordate, so my record will be:

Employee

WorkDate

ApprovDate

Hours

A

10/03/2013

10/03/2013

5

So I tought about creating a Start routine in my cube transfo level and do something as following:

LOOP AT SOURCE PACKAGE into structure

If APROVDAT between FDCP and LDCP

And WORKDATE LT APPROVDAT

WORKDAT = APPROVDAT

ENDIF

ENDLOOP

What do you think about it? What could you advice me?

Thanks.

Amine