cancel
Showing results for 
Search instead for 
Did you mean: 

Allocation for future months of the year

Former Member
0 Kudos

Hi,

I have a forecast situation where we need to allocate to future months of the current year. I am currenlty doing this for the whole year but need to change it so the future months are only affected. Can you please tell me how the logic should be handled for excluding the prior months of the current year.

*RUNALLOCATION

*FACTOR=USING

*NAME=Test

*APP WHAT=Ap1; WHERE=Ap2; USING=Ap2;

*DIM Ap1Dim1 WHAT=Ap1What; WHERE; USING;

*DIM Ap1Dim2 WHAT=FORECAST; WHERE; USING;

*DIM Ap2Dim1 WHAT; WHERE=Ap2Where1; USING=Ap2Using1;

*DIM Ap2Dim2 WHAT; WHERE=Ap2Where2; USING=Ap2Using2;

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

*ENDALLOCATION

Appreciate your help.

Swaroop

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member1192543
Contributor
0 Kudos

Hi Swaroop,

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.

Jeffrey_Holdema
Active Contributor
0 Kudos

You can greatly improve your chance of receiving a helpful answer to your question if you state the version (MS or NW) and the release (5.1, 7.0) of BPC which you are using.

Also notice the sticky [note|; at the top of this forum whereby we announced new dedicated forums for BPC which are the proper place to post your questions regarding BPC in the future.

Thanks and best regards,

[Jeffrey Holdeman|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/jeffrey+holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group