Skip to Content
0
Former Member
Apr 07, 2011 at 03:17 PM

Custom copy script

38 Views

Dear All,

Can someone please explain to me why this is happening.

I have created a script based on several scripts i found on SDN.

I have some knowhow from SAP BPC MS and according to me this should just work.

This is the script.

*XDIM_MEMBERSET C_DATASRC=Upl

*XDIM_MEMBERSET GROUPS=LC

*XDIM_MEMBERSET IN_WASTETYPE=BAS(IWT_ALL)

*XDIM_MEMBERSET MEASURES=PERIODIC

*XDIM_MEMBERSET LINEMAINITEM=<ALL>

*XDIM_MEMBERSET PACKAGETYPE=BAS(PT_ALL)

*XDIM_MEMBERSET PROFITCENTER=BAS(N)

*XDIM_MEMBERSET P_PROFITCENTER=BAS(P_N)

*XDIM_MEMBERSET TIME=%TIME_SET%

*XDIM_MEMBERSET VALUETYPE=ACTUAL,FORECAST,PLANNED

*LOOKUP EBIT

*DIM MEASURES=PERIODIC

*DIM LMITEM: LINEMAINITEM=SCP

*DIM PACKAGETYPE=PT_NONE

*ENDLOOKUP

*WHEN P_PROFITCENTER

*IS <> P_NONE

*WHEN LINEMAINITEM

*IS WTODT

*REC(EXPRESSION=0, LINEMAINITEM=LINEMAINITEM.ZACC1)

*REC(FACTOR=LOOKUP(LMITEM), LINEMAINITEM=LINEMAINITEM.ZACC1)

*ENDWHEN

*WHEN LINEMAINITEM

*IS DT

*REC(EXPRESSION=0, LINEMAINITEM=LINEMAINITEM.ZACC1)

*REC(FACTOR=LOOKUP(LMITEM),LINEMAINITEM=LINEMAINITEM.ZACC1)

*ENDWHEN

*ENDWHEN

*COMMIT

I would say that it is possible to post data from a calculation on a other linemainitem.

In the linemainitem dimension i created a propperty ZACC1, which is a reference to a other linemainitem.

The only thing is, when i run this logic it posts zero's on itself, in this case WTODT and DT and not %VALUE%*LOOKUP on LINEMAINITEM.ZACC1.

Can someone point me in the right direction to make this script work?

Thanks in advantage

Harmen