Copy data to future months

[Former Member]

Hi,

Can anyone advise me of the best code to use to copy data to a future month in a package?

I have account#1 in 2008.JAN to copy to account#2 2009.JAN and the same for FEB, MAR, etc.

I also need to draw together 10 different datasrc to one destination datasrc (hence the need for a package)

Thanks,

Matthew

[Former Member]

Hi,would it be possible for you(i presume we are talking abt Microsoft versions) to copy the "Copy" package and in this one modify the prompt for input selection to include datasrc as well?

regards

shyam

[Former Member]

This works but I'm sure there must be a more efficient way of running this copy...

//=============================================

// Organic Growth

//=============================================

//----

---

// Copy all BAS of LOCAL_TOTAL to INPUT from ACCOUNT 701100 prior year to KEY_10100 current year

//----

---

*SELECT(%MONTHS%,"ID","TIME","[YEAR]='2008' AND CALC='N'")

*XDIM_MEMBERSET ACCTDETAIL=F_NONE

*XDIM_MEMBERSET GROUPS=LC

*XDIM_MEMBERSET ACCOUNT=701100

*XDIM_MEMBERSET CATEGORY=ACTUAL

*WHEN DATASRC

*IS INPUT,LOCAL_FV,LOCAL_ADJS,LOCAL_GAAP,LOCAL_BUS,LOCAL_STAT,AJ_ELIM

*WHEN TIME

*IS 2008.JAN

*REC(TIME=2009.JAN,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.FEB

*REC(TIME=2009.FEB,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.MAR

*REC(TIME=2009.MAR,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.APR

*REC(TIME=2009.APR,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.MAY

*REC(TIME=2009.MAY,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.JUN

*REC(TIME=2009.JUN,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.JUL

*REC(TIME=2009.JUL,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.AUG

*REC(TIME=2009.AUG,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.SEP

*REC(TIME=2009.SEP,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.OCT

*REC(TIME=2009.OCT,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.NOV

*REC(TIME=2009.NOV,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*WHEN TIME

*IS 2008.DEC

*REC(TIME=2009.DEC,ACCOUNT=KEY_10100,DATASRC=INPUT)

*ENDWHEN

*ENDWHEN

*COMMIT

[james_lim]

Mat,

You can just use copy package then it will copy from 2008.JAN to 2009.JAN.

To merge datasrc, you need to create new conversion file of Data Manager.

When you run the copy package, you should select that new conversion file then it will convert from 10 different source to one and copy it to destination.

James.

[Former Member]

James,

Thanks for the help. However we are not loading data so we are unable to use a conversion file. We are copying data from one month to another month.

Matthew

[Former Member]

You should be able to achieve this with the standard copy package.

[Former Member]

The standard copy package does not allow many (DataSrc) to one copy.