on ‎2016 Sep 23 8:45 AM
Hello,
I'm doing an allocation in SAP BPC NW 10.1 and wondering the next questions:
1) Is it possible to specify the WHERE parameter with many receivers?
I saw in the sap help and it looks like it is but I have tried this option:
*DIM CST_ELMNT WHAT=BAS(TOTAL); WHERE=52,53,54;
And it always works only for the first member, I mean if I change the order to "54,53,32" the allocation only runs for 54.
I tried using a property and only works for 52 member id:
*DIM CST_ELMNT WHAT=BAS(TOTAL); WHERE=[ALLOC_IND]="Fleet";
2) How could I set in the WHERE parameter "receiver is different than 7117116,7357313". I tried something like this:
*DIM FUNC_ITEM WHAT=7117116,7357313; WHERE<>7117116,7357313;
But I got a sintaxis error.
Any input is really appreciated.
Thank you & Regards,
GZ
Request clarification before answering.
Hi GZ,
Yes, allocation works fine with multiple members in WHERE. Most probably your USING part didn't calculate for other members that's why it assigned to one member only. If you don't have USING then allocation doesn't know how to distribute WHAT between those members.
<> is allowed with single member only.
Regards,
Gersh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.