BPC 10.1 NW : Allocation script logic approach

[Former Member]

I have a simple allocation requirement but somehow I am getting stuck.

I need to allocate data from all GL accounts where property allocate is Y to one account GL90001, and this should be allocated from cost center CC_1001 to all base members of CC_CORP. I have created dummy cost center members against each of the base member of CC_CORP and the hierarchy for that is CC_COPR_R.

*XDIM_MEMBERSET CATEGORY = Budget

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ENTITY = E1000

*XDIM_MEMBERSET U_PCTR = PC_1000

*XDIM_MEMBERSET AUDITTRAIL = Input

*XDIM_MEMBERSET FLOW = F_999

*XDIM_MEMBERSET TIME = %TIME_SET%

//*XDIM_MEMBERSET P_ACCT = ALLOC_RATIO

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM P_ACCT WHAT=[ALLOCATE]="Y";WHERE = GL90001;USING=[ALLOCATE]="Y"

*DIM COSTCENTER WHAT = CC_1001;WHERE=BAS(CC_CORP);USING=BAS(CC_CORP_R)

*ENDALLOCATION

This works fine when I maintain the ratio for the account which is getting allocated but when I try to do it for a specific ratio account (ALLOC_RATIO), this allocation doesn’t work. I would like to maintain ratio for only one account member and refer that for all allocations.

Can you help me in understanding what am I doing incorrect here.

Thanks

-SM

[former_member186338 · Accepted solution]

Hi Swati,

Not clear - you are using *FACTOR = USING/TOTAL but TOTAL is not defined...

What was the script with ALLOC_RATIO?

*FACTOR = USING

*DIM P_ACCT WHAT=[ALLOCATE]="Y";WHERE = GL90001;USING=ALLOC_RATIO ???

Provide UJKT log!

Vadim

[Former Member]

Thanks for replying. I have some strange system behavior. Today the same code works fine.

I have USING/TOTAL as factor and when I have USING=[ALLOCATE]='Y', it takes the ratio maintained on same GL account (not on ALLOC_RATIO)

and when i use USING = ALLOC_RATIO, it is allocating based on ratio maintained on ALLOC_RATIO account member.

This is expected behavior but somehow I was not able to get it to work earlier.

I will update the thread if I face this issue again in further testing replication of logic for different allocation cycles.

Thanks.

-SM

[former_member186338]

Hi Swati,

If you use USING/TOTAL you have to define both in *DIM!

And still no UJKT log...

Vadim

[Former Member]

Here is the log:

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

LOG:

-----

-----

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

CATEGORY:Budget,

RPTCURRENCY:USD,

ENTITY:E1000,

U_PCTR:PC1000,

AUDITTRAIL:Input,

FLOW:F_999,

TIME:2006.01,

P_ACCT:WHAT:[ALLOCATE]="Y",WHERE:GL90001,USING:A_ALLOC_RATIO,TOTAL:

COSTCENTER:WHAT:CC1001,WHERE:BAS(CC_CORP),USING:BAS(CC_CORP_R),TOTAL:

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

WHAT data: 1 records.

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

Existing WHERE data: 5 records.

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

USING data: 5 records.

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

TOTAL data: 1 records.

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

--Records succeeded to write back : 5

--Records failed to write back :--Records failed to write back : 0

SCRIPT RUNNING TIME IN TOTAL:4.00 s.

LOG END TIME:2015-01-08 09:57:34

[former_member186338]

Look on "TOTAL:" - undefined!!!

And provide FULL log with LGX generated!

Vadim

[Former Member]

Yes Vadim, I did notice that but USING and USING/TOTAL was giving me same results, without defining TOTAL in *DIM.

I can remove Total from the factor.

Apologies about missing LGX:

LGX:

*XDIM_MEMBERSET CATEGORY = Budget

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ENTITY = E1000

*XDIM_MEMBERSET U_PCTR = PC1000

*XDIM_MEMBERSET AUDITTRAIL = Input

*XDIM_MEMBERSET FLOW = F_999

*XDIM_MEMBERSET TIME = 2006.01

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM P_ACCT WHAT=[ALLOCATE]="Y";WHERE = GL90001;USING=A_ALLOC_RATIO

*DIM COSTCENTER WHAT = CC1001;WHERE=BAS(CC_CORP);USING=BAS(CC_CORP_R)

*ENDALLOCATION

*COMMIT

LOG:

LOG:

-----

-----

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

CATEGORY:Budget,

RPTCURRENCY:USD,

ENTITY:E1000,

U_PCTR:PC1000,

AUDITTRAIL:Input,

FLOW:F_999,

TIME:2006.01,

P_ACCT:WHAT:[ALLOCATE]="Y",WHERE:GL90001,USING:A_ALLOC_RATIO,TOTAL:

COSTCENTER:WHAT:CC1001,WHERE:BAS(CC_CORP),USING:BAS(CC_CORP_R),TOTAL:

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

WHAT data: 1 records.

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

Existing WHERE data: 5 records.

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

USING data: 5 records.

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

TOTAL data: 1 records.

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

--Records succeeded to write back : 5

--Records failed to write back :--Records failed to write back : 0

SCRIPT RUNNING TIME IN TOTAL:4.00 s.

LOG END TIME:2015-01-08 09:57:34

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

Earlier the data records to write back were zero.

[former_member186338]

"Yes Vadim, I did notice that but USING and USING/TOTAL was giving me same results, without defining TOTAL in *DIM.

I can remove Total from the factor."

Sometimes you will have the same results, sometimes - not! Let's write scripts according to specifications!

And what is the issue now??

Vadim

[Former Member]

Now the issue is not coming Vadim. As I mentioned today, the same code is working fine now.

[former_member186338]

Then close the discussion

Vadim

[bhagyesh_ravange]

Hello Swati,

Could you post the UJKT script result. Also does your member ALLOC_RATIO has property "Y"?

Regards

Bhagyesh Ravange