cancel
Showing results for 
Search instead for 
Did you mean: 

Many to Many Allocation

Former Member
0 Kudos

I need to allocate using the following scenario:

Source:

Account = AC1

Entity = ET1

Target:

Account = AC1

Entity = All

Allocation Criteria as per file

I tried the following Code:


*RUNALLOCATION
*FACTOR=USING/100
*DIM ENTITY WHAT=CC1;WHERE=<ALL>;
*DIM ACCOUNT WHAT=CE1;WHERE=<<<;USING=Criteria
*ENDALLOCATION

but this did not give the required allocation.

Can anyone please help me out in how to proceed to get this ?

Many Thanks in Advance!

Abhinay

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

can u try

*RUNALLOCATION

*FACTOR=USING/100

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

*DIM ACCOUNT WHAT=CE1;WHERE=<<<;USING=Criteria

*ENDALLOCATION

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

Former Member
0 Kudos

Is criteria an account in the dimension?

criteria should be a valid member in the account dimension and it should have the allocation % assigned to it, when the logic is triggered.

Former Member
0 Kudos

yes, I have included the criteria as a member. Previously, I have successfully ran allocations for one to one. I am stuck here. Please help me out ....

Edited by: Abhinay J B on Apr 1, 2009 11:39 AM