on 07-06-2014 12:02 AM
Hi experts,
Usually, in BPC, while making allocation, as it is not possible to input data on node, we create technical member.
This process is acceptable only if the number of technical member is not so important;
I m facing that point, where my client has more than 2000 item to be allocated on more than 16000 base level item.
In that last case, what should be your requirement ?
Tks a lot for all your valuables advices,
Best regards,
Olivia
Hi Olivia,
if i have to generate members in bpc dimension from an attribute of characteristic in bw for allocation i usually use end_routine(UJD_ROUTINE) when i load master data. I put a prefix "XX_" and i add two properties; ALLOC = 'Y' and ORJ_NAME = 'YYYY'.
You can use this code but i recommend using a badi.
*SELECT(%ORJNAME%,ORJ_NAME,MATERIAL,ALLOC='Y')
if allocation is property based;
*FOR %P_ORJNAME% = %ORJNAME%
*XDIM_MEMBERSET MATERIAL = XX_%P_ORJNAME%
*FACTOR=USING/TOTAL
*DIM MATERIAL WHAT= XX_%P_ORJNAME% WHERE=[MATL_TYPE]=%P_ORJNAME%.
*NEXT
if allocation is hierarchy based;
*FOR %P_ORJNAME% = %ORJNAME%
*XDIM_MEMBERSET MATERIAL = XX_%P_ORJNAME%
*FACTOR=USING/TOTAL
*DIM MATERIAL WHAT= XX_%P_ORJNAME% WHERE=BAS(%P_ORJNAME%)
*NEXT
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Exactly.
Regards.
Burak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Writeback BADI to allow input on parent level member.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Olivia,
Write-back BADI was introduced when there was no EPM Add-in dis-aggregation functionality. Dis-aggregation has 3 types and if one of them fits your requirements than this is the best approach.
If none of them works for you then I'd think approach that Burak suggested is better. Since you have 2000 Nodes you probably load that Dimension, i.e. you don't maintain it manually. Therefore routine BADI that generates those technical members is least invasive.
I'd suggest, only if none of this works for you then try write-back BADI.
-Gersh
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
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.