BPC 5.1 (release 5.0.496): No values calculated in allocation logic

[Former Member]

Hi experts,

I am using an allocation logic which doesn't calculate values for destination members (entity="CE_GP_2_IN", account "40110_BrStoff").

Some comments concerning that:

- I want to allocate (or copy) values from source entity node "0001_KK" (with correpsonding base level members) and account "UP_BAS_VKABSBR" via an allocation logic to destination entity "CE_GP_2_IN" and account "40110_BrStoff"

- destination members are all base level members

- all other dimensions are equal

- the retrieved value is zero for all time periods

Note:

- an SAP expert told me that the BPC version I use has a bug in the time dimension concerning calculation logics

I have two questions:

1. Where is the mistake in the following logic?

2. How can I allocate values from two independent nodes of the account dimension to one single account via an allocation logic?

*XDIM_MEMBERSET Entity="CE_GP_2_IN", "0001_KK", "0001_KKBRO", "0001_KKBRU", "0001_KKEMS", "0001_KKGRA", "0001_KKGRO", "0001_KKGRU", "0001_KKISA", "0001_KKKRU", "0001_KKUNT", "0001_KKKK1", "0001_KKKK2", "0001_KKKK3"

*XDIM_MEMBERSET Account="UP_BAS_VKABSBR", "40110_BrStoff"

*XDIM_MEMBERSET Category="BUDGETV8"

*XDIM_MEMBERSET Prodline="Prod1"

*XDIM_MEMBERSET Time="2009.ACT","2010.BUDG","2011.PLAN","2012.PLAN"

*RUNALLOCATION

*FACTOR USING/TOTAL

*DIM ACCOUNT WHAT=UP_BAS_VKABSBR; WHERE=40110_BrStoff; USING=<<<; TOTAL=<<<

*DIM CATEGORY WHAT=BUDGETV8; WHERE=BUDGETV8; USING=<<<; TOTAL=<<<

*DIM ENTITY WHAT=BAS(0001_KK); WHERE=CE_GP_2_IN; USING=<<<; TOTAL=<<<

*DIM PRODLINE WHAT=Prod1; WHERE=Prod1; USING=<<<; TOTAL=<<<

*DIM TIME WHAT=BAS(YEAR.INC); WHERE=BAS(YEAR.INC); USING=<<<; TOTAL=<<<

*ENDALLOCATION

*COMMIT

Any hints would be grate!

[Former Member · Accepted solution]

             *FACTOR USING/TOTAL

Try

*FACTOR=USING/TOTAL

(notice the equal sign)

perhaps it works this way.

[Former Member]

A couple of ideas. It looks like your process is more of a copy? Is that true?

One option is to use FACTOR =USING or FACTOR = 1, that will use the value and move it from one set to the other set. You don't need the sections of TOTAL, since no total is use as division.

Plus., is YEAR = to a specific ID or is it meant as a variable? If a variable, It may need %YEAR% as a variable, such as %YEAR%.INC.

Try this and see if it can help.

[former_member1192543]

Hi ,

I have a issue with allocation logic i.e is my scenario require allocation logic or i can write general logic,if yes,can you give a suggestion how to write..

Scenario is..in my plan..

I prepared a schedule for SALES planing...for which i have prepared a input scedule..

My input schedule works like..COLs-SalesAccountits memberset isfiltered using propety i.e test3="C"

ROWs-ENTITY--

---

its memberset is filtered using propety i.e Plants="A"

Time--Taking from CV.

When i take time 2009.INPUT from CV and enter the data for entity for respect salesaccounts and send the data.NEXT,

I want to copy the same data to all the months of 2009...for that iam using allocation like

*RUNALLOCATION

*FACTOR

//*USING

*DIM ENTITY WHAT=Entity; WHERE=<<<: USING=Entity.PLANTS

*DIM SALESAccount WHAT=SALESACCOUNT; WHERE=<<<: USING<>SALESACCOUNT.TEST3

*DIM TIME WHAT=BAS(%YEAR%.TOTAL); WHERE=<<<; USING=%TIME_SET%;

*ENDALLOCATION

will it work my scenario does i need to add any other logic ...

Suggest me sol..

regards,

Naresh.