Skip to Content
0
Former Member
Apr 03, 2012 at 02:47 AM

Allocation or Script ?

18 Views

Hi ,

I want to allocate all entity's( TOTAL) data to null enity for all accounts ( loop) based on persentage .

I wrote aloocation and script also , but both are not working .

Please advise which one easy .

ALLOCATION :

*XDIM_MEMBERSET P_ACCT = 9020101

*XDIM_MEMBERSET CATEGORY = ACTUAL

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET ENTITY = 2002, NA_ENTITY

*XDIM_MEMBERSET PARTICIPATEORG =NA_PARTIORG

*XDIM_MEMBERSET PILLAR =RC_RETAIL

*XDIM_MEMBERSET GEOGRAPHY =NA_GEOGRAPHY

*XDIM_MEMBERSET FLOW = PL99

*XDIM_MEMBERSET INTCO = I_None

*XDIM_MEMBERSET RPTCURRENCY =LC

*XDIM_MEMBERSET AUDITID =ALLOCDRIVER

 

*RUNALLOCATION

*FACTOR=USING/100

*DIM P_ACCT WHAT=9020101; WHERE=<<<; USING=<<<

*DIM ENTITY WHAT=>>>; WHERE=>>>; USING=<<<

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

*ENDALLOCATION

*COMMIT

-------------------------

SCRIPT :


*XDIM_MEMBERSET P_ACCT = 9020101
*XDIM_MEMBERSET CATEGORY = ACTUAL
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET ENTITY = NA_ENTITY
*XDIM_MEMBERSET PARTICIPATEORG =NA_PARTIORG
*XDIM_MEMBERSET PILLAR =RC_RETAIL
*XDIM_MEMBERSET GEOGRAPHY =NA_GEOGRAPHY
*XDIM_MEMBERSET FLOW = PL99
*XDIM_MEMBERSET INTCO = I_None
*XDIM_MEMBERSET RPTCURRENCY =LC
*XDIM_MEMBERSET AUDITID =ALLOCDRIVER

*LOOKUP MGMREPORTING

*DIM PERSEN:ENTITY="NA_ENTITY"

*ENDLOOKUP

*WHEN P_ACCT
*IS 9020101

*REC(EXPRESSION= %VALUE% *LOOKUP(PERSEN) , RPTCURRENCY= SGD )

*ENDWHEN

*COMMIT

Pls advise ...

Thanks.