Allocation or Script ?

[Former Member]

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.

[Former Member]

Hi Chanti,

Your allocation script was not very clear. You have a statement:

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

What is this supposed to do?

Both the scripts are doing different calculations.

First let me try to understand the scenario. You are trying to take the value of the TOTAL entity and store it in the NA_ENTITY. You dont need any allocation engine for this. This is a simple copy.

*WHEN ENTITY
*IS *
   *REC(ENTITY = NA_ENTITY)
*ENDWHEN

The above script will take the total value of all the base members of TOTAL entity and post it in NA_ENTITY.

Secondly, what exactly are you trying to achieve with the script?

Hope this helps.

[former_member210696]

Hi Chanti,

You should probably use script logic. I feel that it's probably the LOOKUP instruction. In your MGMREPORTING application, what are other dimensions?? When you are trying to fetch some transaction data from MGMREPORTING through LOOKUP, you should mention all dimensions and a certain dimension member wrt that dimension.

In short,

*DIM PERSEN:ENTITY="NA_ENTITY" instruction should be written for all dimensions in MGMREPORTING. And, probably then, it might work.