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