Property of Member in REC statement

[kyle_tetschlag]

I am trying to run an allocation that takes the NETSALES amount multiply by percent to get to a Delivery account. The NETSALES are saved in 2018.01 for example while the percent is saved to 2018.INP (a property of 2018.01). How do I tell the REC to pull the property of the time period so I can run based on time selected in DM package?

*SUB RUNALLOC(AcctTo,AcctInp,ProdFrom,ProdInp)
*XDIM_MEMBERSET ACCOUNT = NETSALES
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET CUSTOMERSEGMENT = BAS(TOTALEM)
*XDIM_MEMBERSET DATASRC = BAS(ALL_COPA)
*XDIM_MEMBERSET PRODUCT = BAS(ProdFrom)
*XDIM_MEMBERSET REPORTINGGROUP = BAS(KOH_EUROPE)
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET RPTCURRENCY = USD,LC,EUR


*WHEN ACCOUNT
*IS NETSALES
*REC(FACTOR = -([ACCOUNT].[AcctInp],[DATASRC].[INPUT],[PRODUCT].[ProdInp],[REPORTINGGROUP].[INPUT_KBEMEA],[RPTCURRENCY].[LC],[TIME].[2017.INP]),ACCOUNT = AcctTo)
*ENDWHEN
*ENDSUB

RUNALLOC(ZFADELIVERY,ZFADELIVERY_PCTNS,FINEM_JD_CERMCS,EM_JD_CERMCS.INP)

[former_member186338]

You can have only one LOOKUP for the same cube in script. In this LOOKUP you have to define 120 labels:

*LOOKUP FINANCE 
*DIM L1:ACCOUNT=ZFADELIVERY_PCTNS
*DIM L1:PRODUCT=EM_JD_CERMCS.INP 
*DIM L2:ACCOUNT=ZFADELIVERY_PCTNS
*DIM L2:PRODUCT=EM_JD_TS.INP
//... 120 pairs up to L120 
*DIM DATASRC=INPUT 
*DIM REPORTINGGROUP=INPUT_KBEMEA 
*DIM RPTCURRENCY=LC 
*DIM TIME=TIME.AVGMYTD // No Label here!
*ENDLOOKUP

*SUB RUNALLOC(AcctTo,ProdFrom,LookupLabel) // LookupLabel - L1...L120

*XDIM_MEMBERSET ACCOUNT = NETSALES 
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET% 
*XDIM_MEMBERSET CUSTOMERSEGMENT = BAS(TOTALEM) 
*XDIM_MEMBERSET DATASRC = BAS(ALL_COPA) 
*XDIM_MEMBERSET PRODUCT = BAS(ProdFrom) 
*XDIM_MEMBERSET REPORTINGGROUP = BAS(KOH_EUROPE) 
*XDIM_MEMBERSET TIME = %TIME_SET% 
*XDIM_MEMBERSET RPTCURRENCY = USD,LC,EUR 

*WHEN ACCOUNT 
*IS NETSALES 
*REC(FACTOR = -LOOKUP(LookupLabel),ACCOUNT = AcctTo) // LookupLabel used here
*ENDWHEN 
*ENDSUB 

RUNALLOC(ZFADELIVERY,FINEM_JD_CERMCS,L1)
RUNALLOC(ZFADELIVERY,FINEM_JD_TS,L2)
//... 120 RUNALLOC