Skip to Content
author's profile photo Former Member
Former Member

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

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2009 at 01:44 PM

    *FACTOR USING/TOTAL

    Try

    *FACTOR=USING/TOTAL

    (notice the equal sign)

    perhaps it works this way.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2009 at 12:58 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.