Skip to Content
0
Former Member
Dec 01, 2009 at 02:04 PM

Executing default logic in target application

18 Views

Hi again

I have 2 applications one for legal consolidation (FINANCE) and one for forecast (EXPECTED). As part of the monthly process current period figures are copied from FINANCE to EXPECTED using the following logic

// Determins the current month specified in the Category dimension by property SubmitMonth. The values will be copied to the same month in the Expected applicaton

*SELECT(%ThisMonth%, "SubmitMonth", "CATEGORY", "[ID]= 'ACTUAL' ")

//Based on the current month (%ThisMonth%) get the destination category for EXPM

*SELECT(%EXPMDest%, "EXPMDest", "TIME", "[ID]='%ThisMonth%' ")

*DESTINATION_APP=EXPECTED

//*CLEAR_DESTINATION

//*DESTINATION TIME = %ThisMonth%

*XDIM_MEMBERSET CATEGORY = ACTUAL

*XDIM_MEMBERSET TIME = PRIOR, %ThisMonth%

*XDIM_MEMBERSET CONSOLVIEW = LC

*XDIM_MEMBERSET ACCOUNT = <ALL>

*XDIM_MEMBERSET ACCDETAIL = <ALL>

*XDIM_MEMBERSET INTCO = <ALL>

*XDIM_MEMBERSET DATASRC = <ALL>

*WHEN TIME

*IS PRIOR

*WHEN TIME.MONTHNUM

*IS 12

*ELSE

*WHEN ACCOUNT.GROUP2

*IS "PL"

*WHEN DATASRC

*IS CalcPreAdj

*REC(FACTOR = -1, CATEGORY = %EXPMDest%, TIME = "%ThisMonth%")

*ELSE

*REC(FACTOR = -1, CATEGORY = %EXPMDest%, DATASRC = INPUT, TIME = "%ThisMonth%")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ELSE

*WHEN DATASRC

*IS CalcPreAdj

*REC(CATEGORY = %EXPMDest%, TIME = "%ThisMonth%")

*ELSE

*REC(CATEGORY = %EXPMDest%, DATASRC = INPUT, TIME = "%ThisMonth%")

*ENDWHEN

*ENDWHEN

*COMMIT

When this logic is executed, default logic in the target application (EXPECTED) is NOT executed and it should be. How do I spcifiy that the default logic in EXPECTED should be run after data are copied.