Skip to Content
0
Former Member
Oct 18, 2012 at 09:42 AM

*CLEAR_DESTINATION

76 Views

Hi All

I have a scenario where in we transfer data in one application to another application

the issue is i need to clear first the destination app so amounts will be clear before i transfer new data.

The problem is when the data in the source application the zero amounts has been compressed and becomes null therefore my script can't see any records and skip the said intersection and in that case i can't clear anymore the destination source

when i try to use Clear_Destination it can't clear the destination app instead it clears all intersection. when i try to specified the clearing intersection i can't indicate the specific entity since my source application have the entity dimension name as cstcenter and destination app entity name as Subbrand.

here's the sample code

*DESTINATION_APP = FINANCE

*ADD_DIM ISUBBRAND =NO_ISUB

*RENAME_DIM CSTCENTER = SUBBRAND

*SELECT(%TIMEID%,"[BUDGET_YR]","VERSION","ID='%VERSION_SET%'")

*SELECT(%YR%,"[YEAR]","TIME","TIMEID='%TIMEID%'")

*SELECT(%TIME%,"[ID]","TIME","TIMEID>='%TIMEID%' AND LEVEL='MONTH' AND YEAR='%YR%' AND ID<>'%YR%.INP'")

*XDIM_MEMBERSET DATASRC=11_INPUT,11_AMT

*XDIM_MEMBERSET ACCOUNT<>TOTAL_OPEX

*XDIM_MEMBERSET ACCOUNT<>60000560

*XDIM_MEMBERSET ACTTYPE=<ALL>

*XDIM_MEMBERSET TIME=%TIME%

*WHEN CSTCENTER.OFC_FLD

*IS PRD

*REC(FACTOR=1,CSTCENTER=CSTCENTER.FIN_SUB)

*ENDWHEN

*COMMIT