Skip to Content
0
Former Member
Aug 31, 2007 at 01:15 AM

Help Required on Update Routine

11 Views

Hello gurus,

I have a requirement to write a update routine between ODS to Cube.

In ODS I have 0PSTNG_DATE info object.

In cube I have 0FISCPER, 0FISCPER3 & 0FISCYEAR. Now i need to determine 0FISCPER from 0PSTNG_DATE.

<b>Logic :</b>

If 0POSTNG_DATE is before 15 of the current month

use previous 0FISCPER period

if 0postng_date is after 15 or 15 of the current month

use current 0FISCPER period

Can one hlep me with the code pls.

Cheers

POPS