BPC 7.0 NW ALLOCATION PARAMETERS

[former_member301564]

Hi,

Is it available, in BPC 7.0 NW, the following syntaxes?

*RUNALLOCATION

*FACTOR=

*NAME={allocation name}

*APP [WHAT={app name};] [ WHERE={ app name };] [USING ={ app name }]

*DIM {dim name} WHAT=; WHERE=;[USING =;] [TOTAL=]

*DIM u2026

*ENDALLOCATION

May I reference another application?

*APP [WHAT={app name};] [ WHERE={ app name };] [USING ={ app name }]

Regards!

[Former Member]

Note 1318471 - BPC7NW: "WHAT" in *RUNALLOCATION not work

may help.

[SEdelstein]

Hi Bernardo-

I can conform Jeff's comment:

The ability to access and post to multiple applications using Allocation does not currently work. All records need to be sourced from within the same (home, or "calling") application.

I was able to successfully allocate in a BPC70NWSP04 system using the following code:

*RUNALLOCATION 
*FACTOR=USING/TOTAL 
*APP WHAT=PLANNING; WHERE<<<;USING<<<;TOTAL<<< 
*DIM P_ACCT WHAT=CE0004010; WHERE=CE0004020; USING=CE0004030; TOTAL=<<< 
*DIM ENTITY WHAT=A1000; WHERE=<<<; USING=<<<; TOTAL=<<< 
*DIM TIME WHAT=2009.JAN; WHERE=>>>; USING=BAS(2009.TOTAL); TOTAL=<<< 
*ENDALLOCATION

(Explanation: a record exists for the data intersection at P_ACCT CE0004010/Entity=A1000/TIME=209.JAN...this record is allocated based upon the value distribution in all months of 2009 for the P_ACCT CE0004030, the allocated values are then stored in all months of 2009 and P_Acct CE0004020)

The follow code also "ran", but posted the allocated values in the wrong application (values were posted into the application called "PLANNING", not the application "PLANNING2" as coded:

*RUNALLOCATION              
*FACTOR=USING/TOTAL 
*APP WHAT=PLANNING; WHERE=PLANNING2; USING=PLANNING; TOTAL=PLANNING 
*DIM P_ACCT WHAT=CE0004010; WHERE=CE0004020; USING=CE0004030; TOTAL=<<< 
*DIM ENTITY WHAT=A1000; WHERE=<<<; USING=<<<; TOTAL=<<<     
*DIM TIME WHAT=2009.JAN; WHERE=>>>; USING=BAS(2009.TOTAL); TOTAL=<<<         
*ENDALLOCATION 

Regards,

Sheldon

[Former Member]

Experts,

When running the following allocation logic in NW 7.0 sp2, I get an error (explained below):

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM GL_ACCOUNT WHAT=TOTAL_COGS; WHERE=<<<; USING=TOTAL_REVENUE; TOTAL=<<<

*DIM DATASRC WHAT=INPUT; WHERE=ALLOC; USING=INPUT; TOTAL=<<<

*DIM SEGMENT WHAT=90; WHERE=BAS(PACKAGING); USING=<<<; TOTAL=<<<

*DIM COMPANYCODE WHAT=WW_TOT; WHERE=<<<; USING=WW_TOT; TOTAL=<<<

*ENDALLOCATION

I can validate and save. However, when I run I get an error saying: "RUN_LOGIC:Missing [] on property name: WHAT=TOTAL_COGS.

Failed

Any ideas?

[pravin_datar]

I assume TOTAL_COGS is a parent member. Can you pl try with a base member instead of a prent member?

Regards

Pravin

[Former Member]

Jim,

Try using BAS(PARENTMEMBER) everywhere including in WHAT range. I know providing PARENTMEMBER values in WHAT region used to work in Microsoft version.

Rahul

[Former Member]

//REVERSING ENTRIES

*RUNALLOCATION

*FACTOR = -1

*DIM DATASRC WHAT=INPUT; WHERE=ALLOC_REVERSE;

*DIM SEGMENT WHAT=90; WHERE=<<<;

*DIM COMPANYCODE WHAT=105; WHERE=<<<;

*ENDALLOCATION

Changed to evaluate the following, but still get same error using basemembers. I've seen mention of a possible issue with sp2, but can anyone verify?

[pravin_datar]

What SP are you on? Also what error do you get when you use basemembers?

Regards

Pravin

[Former Member]

sp 2.0. Error reads "RUN_LOGIC:Missing [] on property name: WHAT=INPUT."

[Former Member]

Seems like there is a dot '.' after 'INPUT'. Remove that dot '.'

[Former Member]

no dot...just copied it in by mistake

[Jeffrey_Holdema]

Sorry, but to my knowledge it is not possible to have *RUNALLOCATION cross applications.

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