Skip to Content
0
Former Member
Feb 03, 2012 at 07:33 PM

I need Data manager dynamic script for Allocation logic

72 Views

Hi,

I need Data Manager Dynamic script for Allocation logic. I have written the script in this. Let me know the below logic is the right one. My script file is TEST.LGF and I have hard coded in the logic because I want to run it directly when I run a package after passing the values from the front end

Dynamic script for Allocation Logic

DYNAMIC SCRIPT: (PACKAGE----/CPMB/ALLOCATION)

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")

TASK(/CPMB/ALLOCATION_LOGIC,SUSER,%USER%)

TASK(/CPMB/ALLOCATION_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/ALLOCATION_LOGIC,SAPP,%APP%)

TASK(/CPMB/ALLOCATION_LOGIC,LOGICFILENAME,TEST.LGF)

Allocation Logic with Formula

........................................................................................................................................................................................................

*XDIM_MEMBERSET P_ACCT=CE0004010,CE0004020,CE0004030,CE0004210

*XDIM_MEMBERSET CATEGORY=PLAN

*XDIM_MEMBERSET P_CC=India

*XDIM_MEMBERSET P_DATASRC=UPLOAD

*XDIM_MEMBERSET P_ACTIVITY=Repair

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET TIME=2009.JAN.2009.APR,2009.APR,2009.MAY

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM P_ACCT WHAT=CE0004530; WHERE=CE0004540; USING=CE0004510; TOTAL=CE0004520

*DIM CATEGORY WHAT=PLAN; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM P_CC WHAT=India; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM P_DATASRC WHAT=UPLOAD; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM P_ACTIVITY WHAT=Repair; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM RPTCURRENCY WHAT=LC; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM TIME WHAT=2009.OCT; WHERE=2009.NOV; USING=2009.AUG; TOTAL=2009.SEP

*ENDALLOCATION

......................................................................................................................................................................................................

Could you please guide me in this and update me.

Thanks and Regards,

Krishna.